SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Read only Rights with Create View - Help

  I am trying to set up permissions in SQL 2005 to give a user Read Only rights to the table, but he …

  aliciakw

  14 replies

  10 years, 3 months ago

  By: andre.quitta

• Error in Query

  Hi, it gives me this Error Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_C…

  immaduddinahmed

  1 replies

  10 years, 3 months ago

  By: Joie Andrew

• How to track a sqlserver login if password changed how to know who has changed its a 2005 standard edition

  hi geeks How to track a sqlserver login if password changed how to know who has changed its a stan…

  naga.rohitkumar

  8 replies

  10 years, 3 months ago

  By: Eric M Russell

• How to eliminate deadlocks involving 'Select' statements

  We are experiencing deadlocks with several 'select' statements acquiring shared locks. To overcome …

  netflix_y

  11 replies

  10 years, 3 months ago

  By: Jeff Moden

• OBDC cant connect

  Hi Team, I have one server that cannot connect to a remote SQL server. Any other server or machine …

  michael.hansen

  2 replies

  10 years, 4 months ago

  By: michael.hansen

• Barcode 128 generator (using scalar function)

  I'm looking for a barcode generating Function that uses the standard Code128. Apparently no functio…

  a_ud

  12 replies

  10 years, 4 months ago

  By: sunshineyoyo2

• odbc sql server driver sql server does not exist or access denied

  Hello, For a few weeks now I have been trying to create an odbc connection with microsoft access an…

  spids11

  1 replies

  10 years, 4 months ago

  By: runaldo

• Purge

  Hi gurus I would like to know if the following is possible I have a DB that I would like to purg…

  guaro5555

  1 replies

  10 years, 4 months ago

  By: John Mitchell-245523

• scheduling a DBmail command

  Hi, I have a stored procedure that generates and email once run. This is working perfectly. Howeve…

  aastevo

  1 replies

  10 years, 4 months ago

  By: JeremyE

• Database problems

  Hi Experts, Does anyone have any ideas how I can fix / repair a corrupted database that hangs when …

  MortonQuen

  3 replies

  10 years, 4 months ago

  By: ReeDonald

• Grouping with PIVOT?

  Good morning SSC, I have the following query that returns the data needed but too much data. I want…

  kabaari

  1 replies

  10 years, 4 months ago

  By: Eirikur Eiriksson

• last_user_update in sys.dm_db_index_usage_stats

  Dear all, I have restored a database from server B to server A. When I modified a record in a table…

  clement.store

  3 replies

  10 years, 5 months ago

  By: SQL_Hunt

• How to find the owner of the table in MSSQL 2005?

  Hi, The question is: the default owner of the table was set to the principal name by the "ALTE…

  kasper-383322

  3 replies

  10 years, 5 months ago

  By: barbara.roy

• Extract .mdf from .bak in SQL Server 2005

  I have a 6GB .bak file that, when check it in the file to use for restore, the file shows 'Incompl…

  GregoryGood

  2 replies

  10 years, 5 months ago

  By: JaysonHopk

• faster in SSMS slower in proc

  If I embed the sql inside a proc, it takes over an hour but if i just run as is, it executes in les…

  SQL_Surfer

  6 replies

  10 years, 5 months ago

  By: Alan Burstein