Sql-server-2005 Questions

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

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.

There is a

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

In our web-app we use php5.2.6 + pdo to connect to a sql server 2005 database and store russian texts. database collation is

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

Is there an easy way to remove an identity from a table in sql server 2005? when i use management studio, it generates a script that

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

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

Working on a common codebase, one developer is running sql server express 2005 and the other 2 are running sql server 2005. everything is working

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 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

I wonder how you guys manage deployment of a database between 2 sql servers, specifically sql server 2005. now, there is a development and a live

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

--actually this is calculated based on some logic but here -- i have hard coded it to keep it simple. declare @count int = 4 --to