I am looking to manage a sql server 2008 db using management studio 2005. the reason for this is because our server is a 64-bit machine and we
I'm working on an open source project that uses sql server 2005 as the data store. we need a db compare tool to generate diff scripts to be able
I have a table say t in sql server 2005 database and it has two columns say a and b, which more often than not won't have any values in them. how
I've noticed that we have a lot of indexes that begin with a certain column and that column has low cardinality (i.e. company and 99% of records
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Currently, if i want to output a sql script for a table in my database, in management studio, i can right click and output a create script.
Is there any way to use inheritance in database (specifically in sql server 2005)? suppose i have few field like
I would like to create a report from a project management system that has been created in lotus notes. i have connected to oracle from ssrs
Problem: i have an address field from an access database which has been converted to sql server 2005. this field has everything all in one field.
How to write stored procedure output directly to a file on an FTP without using local or temp files?
I want to get the results of a stored procedure and place them into a csv file onto an ftp location. the catch though is that i cannot
Has anyone been able to get a variable record length text file (csv) into sql server via ssis? i have tried time and again to get a csv
By using sp_who2 i can get a list of current log-in users and machine names. some users are using sql server log-in user name such as sa. is there
Is there a way to stop the log file from growing (or at least from growing as much) in sql2000/2005? i am running a very extensive process
In ms sql server management studio express, is there a way to set the default author name to my name when i create a stored procedure by right
Has anyone tried installing sql server 2008 developer on a machine that already has 2005 developer installed? i am unsure if i should do
I am trying to enable full-text indexing in sql server 2005 express. i am running this on my laptop with vista ultimate. i understand that
We're in the process of upgrading one of our sql server instances from 2000 to 2005. i installed the performance dashboard
I have some reports in sql server reporting services 2005 that i need to keep audit logs for. the audit log should include who ran what report
This is a question i asked on another forum which received some decent answers, but i wanted to see if anyone here has more insight. the
I'm wanting extra security for a particular point in my web app. so i want to lock the database (sql server 2005). any suggestions or is this even
I'm working on a database for a small web app at my school using sql server 2005. i see a couple of schools of thought on the
I'm getting the following error when trying to connect to a sql server (2005) using jdbc: unhandled token type: unknown token:
I'm using an sql server 2005 hosted in the states. soon we will move the db to europe. i'd like to update the dates in the db to take into account
How to recover a deleted row from sql server 2005 table?
I have an mdf file and no ldf files for a database created in ms sql server 2005. when i try to attach the mdf file to a different sql server,
Below code saying error incorreect syntax near "main" insert into tbl ( 'week', main, a, b, c,
I am working on a console application to insert data to a ms sql server 2005 database. i have a list of objects to be inserted. here i use
I have a primary key that i don't want to auto increment (for various reasons) and so i'm looking for a way to simply increment that field when i
I want get the maximum value for this record. please help me: select rest.field1 from mastertable as m inner join (
I have a series of t-sql statements separated by the special query analyzer batch separator keyword: go if one
Using t-sql i've found that i can't use 'alter index' with the table/index values in variables without getting a syntax error. is there some way
SQL Server: How do I add a constraint to an existing table but only if the constraint does not already exist?
I need to add a constraint to an existing sql server table but only if it does not already exist. i am creating the constraint using the
I have a winforms application created in visual studio 2005 pro, it connects to an sql server 2005 database using the sqlconnection / sqlcommand /
I have a php app running happily on the following system: web app: php version 5.2.3 os: windows server 2003 standard 32
I want to check for data, but ignore it if it's null or empty. currently the query is as follows... select
I am using sql server 2005. i have a table with a text column and i have many rows in the table where the value of this column is not null, but
This is what i have. it looks like ms's example adn i can't figure out why it's not running. i get an invaild column name 'planid' error on this
I've currently got a database with about 20 reference tables, i.e. stuff like products, assets, depots, users, etc. this information is stored in
I am getting the following error when my dts package is scheduled: description: ssis error code
I am working on a code base that has a number of connection strings that access a database server by a specified name. <add
Related to this question, i decided to check the udfs in
Edit: solved, there was a trigger with a loop on the table (read my own answer further below). we have a simple
When i try to create a a new snapshot in sql server reporting services 2005, i get the message: "report history may not be created because the
We have a cube that we are populating the data from the source tables. to get the data to reflect we are calling the "analysis services processing
How do i page results in sql server 2005? i tried it in sql server 2000, but there was no reliable way to do this. i'm now wondering if
I have a table with a structure like the following:
Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?
Have you ever seen any of there error messages? -- sql server 2000 could not allocate ancillary table for view or
For instance, my query is like the following using sql server 2005: select * from table where freetext(searchfield, 'c#')
We're upgrading an existing program from win2k/sql server 2k to windows 2003 and sql server 2005 as well as purchasing a
I wrote a windows service using vb that read some legacy data from visual foxpro databases to be inserted in sql 2005. the problem is this use to
Mysql has this incredibly useful yet proprietary replace into sql command. can this easily be emulated in sql server
I have a history database in sql server 2005 that is used to archive data from live database. i need to add a column in history