SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Need help with a query

  Looking for a little help on a query I am having trouble getting my mind around. No, this is not so…

  keent

  17 replies

  15 years, 4 months ago

  By: WayneS

• Multiply DB Query not working.

  I'm trying to run a query again multiply db and this is what I have so far: Select t1.ACTNUMBR_1, t…

  kbnyny

  8 replies

  15 years, 4 months ago

  By: LutzM

• Is it possible to crosstab xml column

  I have a table with a column that has an xml datatype. Is there a way for me to enumerate through t…

  Stringzz

  8 replies

  15 years, 4 months ago

  By: Adam Gojdas

• SQL server memory usage

  Hi, We released a new version of a system and since then the SQL server is consuming much more memo…

  the_fenix

  6 replies

  15 years, 4 months ago

  By: sdorris-1150234

• Intermittent Error - SQL Server does ot exist or access denied

  I have SQL/Server 2005 running on a Windows 2003 server. We have a very small shop, with about 20 W…

  Joel Ziegler

  3 replies

  15 years, 4 months ago

  By: Joel Ziegler

• Timout expired when logging in from client SSMS

  Hi there - as described I am getting an error of: Timeout Expire. The timeout period elapsed prior …

  Kwisatz78

  12 replies

  15 years, 4 months ago

  By: Jack Corbett

• 2005 Enterprise Ed Transaction Log Backup and 2005 Std Ed Transaction Log Restore

  Can you restore a transaction log from an enterprise sql server 2005 database to a standby database…

  Patti Johnson

  1 replies

  15 years, 4 months ago

  By: Lynn Pettis

• Help with Inserting data into Temp Table

  Hi, I am trying to count number of calls according to 3 different filters and I am using the Insert…

  paul_jacobs

  2 replies

  15 years, 4 months ago

  By: paul_jacobs

• Help with Stored procedure SQL Server 2005 Express

  I support a application that has a Access front end and a SQL Server 2005 Express back end. We star…

  d_drada

  1 replies

  15 years, 4 months ago

  By: Wesley Norton

• FOR XML PATH command is altering data, trying to determine the cause.

  I am doing some good old string concentatenation, and I've been reading up on using for XML Paths c…

  huston.dunlap

  8 replies

  15 years, 4 months ago

  By: huston.dunlap

• Update Statements and Understanding Locks

  I am running an update statement on a single column within a large table (over a million records la…

  huston.dunlap

  2 replies

  15 years, 4 months ago

  By: Grant Fritchey

• Reporting Services issue

  We have a report that the users export to excel and you select the date ranges. It seems that if yo…

  NewbieCoding

  3 replies

  15 years, 4 months ago

  By: Shawn Melton

• Sync Multiple Databases

  Hi, I have one main database on which I used to do some changes. and on the same server I have arou…

  Mak Mohan

  2 replies

  15 years, 4 months ago

  By: Mak Mohan

• Any Way to Programmatically Document Stored Procedures?

  I would like to document parameters, tables, functions called, etc for our stored procedures. We a…

  sing4you

  2 replies

  15 years, 4 months ago

  By: sing4you

• SQL Agent causing xp_cmdshell NULL Output

  Hi there. I have a problem on one of my Dev servers that is puzzling our entire team. We have xp_…

  GMan-447962

  6 replies

  15 years, 4 months ago

  By: GMan-447962