SQL Server Administration

Deleting a SQL Server with a common name

How can we delete a SQL Server named "instance" when more than one item named "instance" is present?

Tracking Table Changes SQL Server 2005

Is there a SQL Server 2005 script that would give all the table_names in a database, the last time they were updated and by whom? I've gotten as far as: select name, modify_date from sys.tables order by name but I can't figure out the "user" part.

Multiple users with access to a table in SQL Server 2005

If more than one user can put in a BEGIN TRAN statement, along with being able to update records, of the same table on SQL Server 2005, what will be the rollback results?

What is seed and reseed in SQL Server?

What is seeding and reseeding in SQL Server? How to use it? Where is it used? What is the purpose?

How to setup for the SQL Database Mail to link with Exchange?

How to setup for the SQL Database Mail to link with Exchange?

Multiple SQL For (AS/400)

For (AS/400) I need to create a source member with multiple sentences of sql: i.e. update aa.... update bb.... update cc.... , and then run these source member with runsqlstm. Is it possible? which is the character to separate between sentences? Thanks in advance

SQL Server 2005 Maintenance Plans - overwrite vs. append

I am trying to create a maintenance plan, but when I use the backup database widget, it defaults to 'append existing...'. I want 'oversrite existing...'. Can anyone help me find where that is set? Thank you Carla

Archiving and Purging Data

We deal with a very large database that grows at an avrage of 50GB a month. The current database size is 700 GB. All the transaction tables are horizontally partitioned to seperate filegroups assigned to a individual data files holding each months data. What would be the best strategy to retain...

SQL 2005 Transaction Logs

I am by no means very good at SQL. I know the basics. I am a network engineer but was recently asked to do a few tasks in a SQL 2005 environment. I currently have a database that is residing off-site and I was asked to import the database and transaction logs so that this server can be used for...

Don't run the SQL Server Account as Local Administrator or member of the Administrator Group?

Based on the advice "Don't run the SQL Server Account as Local Administrator or member of the Administrator Group" Will this setup prevented you from using critical features? How did you get around this? The link below makes reference as to how a critical feature "Automatic Server Restart...

run DBCC SQLPREF on linked server.

I want to run DBCC command on linked server remotly

disk activity is running at 100%

24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?

In an effort to free up SQL Server disk space, how can a DBA know when it is time to drop developers test databases from local servers?

Apart from maintaining a SQL Server checklist to check in with developers, how can a DBA know if restored databases on local servers - that were gotten for developers to test – can be dropped after a few days? This would help increase the available SQL Server disk space. Let’s say about 7 user...

Replication

Can I have multiple Distributors configured on one SQL Server instance? Also, can I have multiple Distributors configured on one SQL Server instance? Finally, can I have multiple Subscribers configured on one SQL Server instance?

jobs runing on the server

hi every 1, i am having a real tough time to figure this one out . i need to find out what jobs are schedule in the server that sends data out to ever . we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another server . i looked at the sysjobs_view , it...

SQL Server 2005 multi-instance cluster

I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?

Merge Replication Identity Ranges

What should the publication range and subscription range be set to for each table with identity ranges, bearing in mind thousands of changes can go into some tables each day. I have 1 Publisher and 9 Subscriptions (Merge) and have started getting "The Publisher failed to allocate a new set of...

In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?

In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?

sql server 2000

i have booted my system with windows xp as user xyz with limited rights not an administrator now problem is i am not able to run sql server.please tell me what should i do to run sql server 2000 in user xyz. *it works with administrator login.

SQL

How to find out if database are crypted