Administering

• Topics

  Started by

  Posts

  Last post

• Permissions required to run SQl serevr profilier

  Hi All, One the user want's run profilier, so I grant view server state access. Now they can open p…

  krishnaprasad14

  2 replies

  13 years ago

  By: krishnaprasad14

• How to determine if SQL Server and O/S are 32-Bit or 64-Bit?

  We are running SQL Server 2000 (SP4) 8.00.2055 on Microsoft Windows Server 2003 R2 Standard Edition…

  HookSQLDBA7

  17 replies

  13 years ago

  By: daftmoo

• optimize for ad hoc workload

  Could someone please help me? When trying to configure "optimize for ad hoc workload" in a 2005 Dev…

  SQL Show

  2 replies

  13 years ago

  By: SQL Show

• Executing sql query from select t_sql from table1

  hello guys, can we get recordset from the query that we saved in the recordset ?? CREATE TABLE [db…

  xmozart.ryan

  6 replies

  13 years ago

  By: xmozart.ryan

• Database stuck in restoring mode

  SQL Server 2005 I ran Restore with recovery and now getting Msg 927, Level 14, State 2, Line 1 Data…

  Kasnut

  3 replies

  13 years ago

  By: Gail Shaw

• Public Role Permissions

  I have been assigned to deal with the public role and I have a few questions. I am required to rem…

  jayoub

  1 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Moving data from one server to another

  Quick question about moving data from one database table to another. I have one test environment an…

  jenny 12957

  1 replies

  13 years ago

  By: lptech

• How to load tables(with data) and dependent objects from DB to the other ?

  hello All , Can someone suggest me how I Can load tables and its dependent objects from one DB to t…

  sqlpanther

  4 replies

  13 years ago

  By: crazy4sql

• sqlservr.exe process only growing to 125Mb on very busy system - why ?

  Hi, We have a SQL 2005 instance that's the back end DB for our company helpdesk system. Performance…

  mjwlufc

  10 replies

  13 years ago

  By: Gail Shaw

• Maintenance plan getting failed for system db and user db

  We have two different Maintenance plan for system database and user database doing reindexing for …

  anjalichahal89

  7 replies

  13 years ago

  By: John Mitchell-245523

• How to get common Tables between 2 databases?

  Hello All, I am sure some of the admin might have gone thorugh the same situation, I need a script …

  sqlpanther

  2 replies

  13 years ago

  By: sqlpanther

• Where's the autogrowth?

  So every Sunday we run a custom reindex on a 2005 SQL Server with ~30 DBs on it. Takes the better p…

  ken.trock

  2 replies

  13 years ago

  By: ken.trock

• error 18272/16/1: during restore restart, an i/o error occurred ... *.CKP file not found.

  I'm getting the above error on my DR server. The logs are shipped from live to DR & I now get …

  snomadj

  2 replies

  13 years ago

  By: snomadj

• Maintenance plan DB bAckup plan failing

  I have scheduled the DB backup in our server but frequently its failing with below error Standard …

  jamessdba

  2 replies

  13 years ago

  By: Meet George Jetson

• Querry getting delyaed

  Hi We have a table which contains allmost 1 lak to 2 lak of records querring on that table getting …

  mpradeep23

  2 replies

  13 years ago

  By: Lynn Pettis