Administering

• Topics

  Started by

  Posts

  Last post

• Copy Only restore taking really long time

  Are copy only restores supposed to take longer than normal restores? I had restore a production dat…

  jshurak

  10 replies

  15 years ago

  By: jshurak

• Metadata for computed column does not match column definition

  I have a sql 2005 database that I backed up from my laptop, and restored on a client's sql server. …

  shashi kant

  8 replies

  15 years ago

  By: shen-dest

• Database compatibility level(s) - log/history

  Hi all, Is it possible to find out the history of compatibility levels for a particular SQL Server …

  Danb7183

  14 replies

  15 years ago

  By: Orlando Colamatteo

• Random timeout running a stored proc - drop recreate fixes

  Hi all, So I work with a largish database (30 gig) sql 2005 with a .net 3.5 web front end on a 10 …

  amjid.qureshi

  2 replies

  15 years ago

  By: TheSQLGuru

• DBCC DBREINDEX ERROR

  I tried reindexing a table...but below error is coming Server: Msg 1505, Level 16, State 1, Line 1 …

  shanila_minnu

  6 replies

  15 years ago

  By: Gail Shaw

• differing open tran results

  this is on sql2005 server and log keeps growing due to an open transaction. The dbcc open tran sho…

  danschl

  1 replies

  15 years ago

  By: Gail Shaw

• Scripting server & database level permissions in SQL 2005

  Hi. Does anyone know if there is a way to script all the server-level login permissions as well as …

  Vicki Peters

  3 replies

  15 years ago

  By: Skybvi

• Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error

  Can someone please help me why I am getting this error? Msg 7399, Sev 16, State 1, Line 1 : The OLE…

  Krasavita

  23 replies

  15 years ago

  By: Orlando Colamatteo

• convert ntext to varchar

  can someone please advice me on how to convert ntext data type to varchar? I think ntext data type …

  curious_sqldba

  11 replies

  15 years ago

  By: curious_sqldba

• Same database in two places

  Hi, My boss asked how can we have one database in one place and the same database in other place pe…

  river1

  12 replies

  15 years ago

  By: steveb.

• SQLIO / SQLIOISM: Must be installed on sql host?

  I've been thinking of using these but wondered if they had to be installed on the sql host -- which…

  Indianrock

  7 replies

  15 years ago

  By: Gail Shaw

• Maintenance plan

  Hi I have a Navision production database on SQL 2005 (Nav 4.0 SP3). I release the following mainten…

  jvElecenter

  12 replies

  15 years ago

  By: Ninja's_RGR'us

• Can you track changes made to a database

  Good day all Is it possible to track changes which were made to the db's. Why I ask I've seen few s…

  SQL_Student

  3 replies

  15 years ago

  By: SQL_Student

• Which databases are being used SQL 2005- (Like to cleanup all those not being used)

  Good Morning Is It possible to monitor which db's are in use/or being used. We upgrading to SQL 200…

  SQL_Student

  5 replies

  15 years ago

  By: SQL_Student

• Is it safe to restart sql server service?

  I know that DB recovery happened every time we restarting service. But is it safe, can it result in…

  Yuri55

  3 replies

  15 years ago

  By: Yuri55