SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Debugging capabilities of SQLServer Mgmnt Studio?

  Is there any tool that will let me debug, or rather run step by step scripts in SQLServer Mgmnt Stu…

  MrBaseball34

  10 replies

  18 years ago

  By: GSquared

• 'APPEND' is not a recognized option

  Hi, When I try to modify a trigger that I have made in SSMS for a table I get the following error: …

  icekube12jr

  2 replies

  18 years ago

  By: icekube12jr

• One Hour Query that used to take 13 minutes

  I recently upgraded to SQL Server 2005. Prior to upgrading, the query below runs every hour for 15 …

  pino_daddy

  24 replies

  18 years ago

  By: Les Cardwell

• Can you explain what all this means? Want to know how you determine whether a table needs to be defragged or not. . .

  I ran DBCC SHOWCONTIG (' ) with fast,ALL_INDEXES and got: TABLE level scan performed. - Pages Scann…

  KTG

  5 replies

  18 years ago

  By: Gail Shaw

• Parse Multiple Substrings Between 2 Characters

  Hi, I'm having a problem that I just can't seem to solve. I've been googling around this morning an…

  bellsy

  2 replies

  18 years ago

  By: Ken McKelvey

• Can SQL2005 be installed on top of SQL2000 and replace it as the default database?

  Can SQL2005 be installed on top of SQL2000 and replace it as the default database?

  humanbacon

  1 replies

  18 years ago

  By: Crispin Proctor

• Can not connect to SQL Server 2005

  Hello All, I have just installed SQL Server 2005 (including SP's) onto my Windows 2003 Server and c…

  stevenpdingle

  12 replies

  18 years ago

  By: Shabba

• No server found but no error either with Vista

  Everyone else who is having problems with Vista and SS are getting some error messages. I'm not ge…

  magarity

  3 replies

  18 years ago

  By: GSquared

• Assign empty string '' if datetime is null

  hi all, may i know how to assign '' (empty string) for a varible is null which type is datetime? ex…

  hiankhin

  1 replies

  18 years ago

  By: Jeffrey Williams

• Transposing data in sql 2005 - Pivot????

  Hi Folks, I'm trying to transpose some data in sql but using one column in the data to identify dat…

  samaspin

  3 replies

  18 years ago

  By: samaspin

• Named instance & Default Instance. Can we just have Named Instances?

  Just curious if we can have just named instances, selecting one to be the default, or does one inst…

  rmaggio

  9 replies

  18 years ago

  By: GSquared

• Temporary Tables

  Hello, I was hopeing someone could point me to an article or website that has some in-depth informa…

  purplebirky

  21 replies

  18 years ago

  By: purplebirky

• Delete Script

  This is a pretty cool piece of code but I have a question about it. This is a proc to get rid of C…

  JKSQL

  13 replies

  18 years ago

  By: GSquared

• New SQL Server Injection Attack????

  Hi, I ran into this article that is fairly recent. It mentions a new SQL Injection attack. http://w…

  TKE402

  8 replies

  18 years ago

  By: GSquared

• Need help parsing three tables properly into XML from MSSQL2005

  Hello, folks. I have written the following SQL statement: SELECT c.idChemical ,s.chemicalSubLeft …

  vsaletto

  2 replies

  18 years ago

  By: Todd Engen