Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
How to convert a column value from varbinary(max) to varchar in human-readable form?
sql sql-server sql-server-2005 tsqlA table I have no control of the schema for, contains a column defined as varchar(50) which stores uniqueidentifiers in …
sql sql-server-2005 uniqueidentifierI have a table that contains a Xml column: SELECT * FROM Sqm A sample of the xml data of a …
sql-server xml sql-server-2005 sql-server-2008-r2 sqlxmlI am lost in a big database and I am not able to find where the data I get comes …
sql sql-server-2005I dropped a database from SQL Server, however it turns out that my login was set to use the dropped …
sql-server sql-server-2005 ssms default-databaseI have made a dtsx package on my computer using SQL Server 2008. It imports data from a semicolon delimited csv …
sql-server-2005 unicode ssis types non-unicodeArgh! I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server …
sql-server-2005 ssis ssmsI have two SQL Servers (both 2005 version). I want to migrate several tables from one to another. I have tried: …
sql sql-server sql-server-2005 exportGiven the following table in SQL Server 2005: ID Col1 Col2 Col3 -- ---- ---- ---- 1 3 34 76 2 32 976 24 3 7 235 3 4 245 1 792 What is the best way …
sql sql-server tsql sql-server-2005 minMy SQL Server 2005 doesn't restore a backup because of active connections. How can I force it?
sql-server sql-server-2005 backup restore disconnect