Administration

• Topics

  Started by

  Posts

  Last post

• SQL 2000 SP4 to SP3 database copy/restore question

  Is it possible to restore a user database from SQL 2000 SP4 version onto a SQL 2000 SP3 version ser…

  S_DBA

  9 replies

  16 years, 10 months ago

  By: tosscrosby

• How can i create a stored proc on all databases

  Hi I need to create a stored procedure on all database, I know I can use msforeachDB but the proced…

  Dean Jones-454305

  4 replies

  16 years, 10 months ago

  By: Dean Jones-454305

• SQL auditing query

  Hi friends, we have more than 56 porduction server sql 2000 and 2005, so i need one urgent requirem…

  SQL Galaxy

  1 replies

  16 years, 10 months ago

  By: Jack Corbett

• T-sql to excel (bcp)

  Hi, I trie to execute the folowing command: exec master..xp_cmdshell 'bcp "select cod,nome,data f…

  river1

  3 replies

  16 years, 10 months ago

  By: manish.singh-1128425

• Mirrored Database

  ...

  charipg

  5 replies

  16 years, 10 months ago

  By: charipg

• Dose database log contains the HOST_NAME?

  i need to view the database log but need an application that shows the host name

  hanyfarid612

  1 replies

  16 years, 10 months ago

  By: Gail Shaw

• Update dts owners after restore of msdb

  Hi guys I've restored our msdb database from production to one of the QA environments and ran this …

  Moenier Davids

  3 replies

  16 years, 10 months ago

  By: MANU-J.

• How can i check if an object is still in replication

  Hi, I have disabled replication on a SQL installation, but I have a feeling there are still come re…

  Dean Jones-454305

  8 replies

  16 years, 10 months ago

  By: MANU-J.

• Combine Multiple MDF Database Into Single MDF File

  I have a database that was split years ago into multiple MDF files. Now, with moving to a new serv…

  Roger Abram

  3 replies

  16 years, 10 months ago

  By: MANU-J.

• db_name can't find the object sp_name

  I'm working on an access 2000 data project linked to sql server 2000. Recently users started to get…

  peteroc

  2 replies

  16 years, 10 months ago

  By: Jack Corbett

• Installing SQL 2005 x64 client tools on Windows Server 2003 Enterprise Edition (x64)

  Hi All, We have recently got some new HP G6 servers, and we're struggling to get the management st…

  ifx

  1 replies

  16 years, 10 months ago

  By: ifx

• Show permissions for database user

  Hi, If I grant privileges to database user with GRANT statement, is there way to get the list of al…

  radica_pet

  1 replies

  16 years, 10 months ago

  By: matt6288

• MCDBA for sqlserver2000

  what are the papers should i pass to become a MCDBA for sqlserver2000?

  charipg

  9 replies

  16 years, 10 months ago

  By: charipg

• SQL Dependency problem

  Hi All, I was wondering if there was a free way to arrange dependency for SQL objects, especially v…

  Dean Jones-454305

  3 replies

  16 years, 10 months ago

  By: Lowell

• How to Extract User Priviliges

  Hi I want to extract all kind of permission granted to a particular windows user in each DB. Can s…

  ShuaibV

  4 replies

  16 years, 10 months ago

  By: MANU-J.