SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Select ALL logins, users, and user groups shown in SSMS Security > Logins

  I want to select all logins, users, and user groups that are shown in the Security > Logins fold…

  mgmiller

  1 replies

  11 years, 9 months ago

  By: mgmiller

• When vb.net call a stored procedure and not data is returned dataset is not nothing

  what exactly is returned to VB.NET from a called stored procedure when no data is found?

  SqlBound

  3 replies

  11 years, 9 months ago

  By: Mark Eckeard

• A time out occurred while waiting to optimize the query. Rerun the query.

  We have a third party BO running the query around 3AM in the morning. Query uses several views to p…

  SQL_Surfer

  2 replies

  11 years, 9 months ago

  By: Amit Raut

• What are the New Things in Sql Server 2012

  Hi Good Morning EveryBody, Can Anybody Please Explain or give me link to Explain the new things, I…

  SqlSpider...

  4 replies

  11 years, 9 months ago

  By: Luis Cazares

• Finding tempdb contention

  I am having tempdb issue on my server. Everytime it happens, I need to restart the service. Is ther…

  SQL_Surfer

  7 replies

  11 years, 9 months ago

  By: Gail Shaw

• Is this good practice for using a view?

  We have a large lookup table with 200k records. This table is used frequently in a high volume dat…

  raysteve43

  5 replies

  11 years, 9 months ago

  By: Jeff Moden

• Unable to use single user mode due to multiple system account logins

  Hi everyone... Having a bit of a nightmare with this issue... Need to run SQL 2005 in single user m…

  paul.lewis-923281

  7 replies

  11 years, 9 months ago

  By: Balmukund

• error while running test mail

  Hi, I have sql 2005 installed and database mail has been set up. all the parameters have been corre…

  atulyan.aries

  1 replies

  11 years, 9 months ago

  By: andrea.gnemmi

• Datetime as foreign key

  Hi i've got a few tables with start/end date fields in. I also have a calendar table. should i have…

  spin

  1 replies

  11 years, 9 months ago

  By: Johan Bijnens

• MSX - How do I get rid of the master?

  Hi I have a server that is currently mistakenly setup as a master MSX server. I cant for the life …

  Wedge78

  2 replies

  11 years, 9 months ago

  By: bajwa2

• Activity Monitor-ing

  Can anyone explain why Microsoft consistently make the Activity Monitor in SQL Server (whichever ve…

  reuben.anderson

  3 replies

  11 years, 9 months ago

  By: Ed Wagner

• Query Output in a text file

  Hi, My requirement is to run a query and the o/p of the query has to go into a text file (new file …

  haichells

  4 replies

  11 years, 9 months ago

  By: Jeff Moden

• Please help ... Attaching all files in a folder to an e-mail

  Hi, How do I attach all files in a network folder to an e-mail (without zipping) using sp_send_dbma…

  Skypass

  5 replies

  11 years, 9 months ago

  By: Jeff Moden

• Not Able to Connect Sql 2005 Database in Sql 2000

  Hai Every Body I Have a Database Which was attached in Sql Server 2005.When I Try To Attach it in S…

  perireddy.arikatla

  4 replies

  11 years, 9 months ago

  By: Lynn Pettis

• Pushing inserts into SQL server with C# ?

  I want to insert about 5000 (typically, can be 10K+ at times) rows into SQL server at a time. My in…

  blasto_max

  3 replies

  11 years, 9 months ago

  By: Sean Lange