I'd like to know if anyone know any good scripts to automatically analyze fragmentation and reindex for all databases in an instance? Thank you. Ben
We have an application in production which was running great. But, all of a sudden, the response time has become slowly. The development team thinks...
I have a server with 8GB physical memory (SQL Server 2000), and I wanted to expand the memory from 2GB(default) to 6GB using AWE, so I did this: 1....
I have a server with 8GB physical memory, and I wanted to expand the memory from 2GB(default) to 6GB using AWE, so I did this: 1. added /PAE in...
I need to grant permissions to a developer so that she will be able to view and execute all jobs owned by a sysadmin login. But, I don't want to...
I got the following error, and wondered how to solve it, when called a job on server 1 from server 2 using sp_start_job @job_name = 'job1',...
I saved a DTS package as a VB file instead of Structured Storage File. I then tried to open the VB file in DTS Designer, but I got "specified file is...
We're planning on using CCC/Harvest for our version control and configuration management. But, as far as I understand Harvest only allow .txt or...
We cannot access the data in the view via: select * from openquery([90.130.57.30], 'select * from agent_view where convert(varchar,date_time,112) =...
I have been asked to implement database failover to a second site if the primary server fails using SQL Server 2000. Can anyone give me any...
I'd like to know what would be the best way of moving more than 300 stored procedures from one database to another database. The databases are in two...
I'd like to know how to list permissions on objects (tables, views, etc.) for a login user in a database in SQL Server 2000. For example, User1 has...
I know master.dbo.xp_fixeddrives lists all free spaces in the drives of a server. But, I would like to know if anyone know how to list free space in...
I'd like to know how to resotre a .bas file, which was incidentally saved as VB file in DTS designer, back to a DTS package. I can open a package in...
Does anyone know how to change the owner of a User Defined Data Type? Thanks, Ben
I wanted to use Performance Monitor to log data and selected 8 counters that I wanted to monitor. I saved the log file as .csv in C:PerfLogs. But,...
I'd like to know if there's a way to list all tables, views that are being used within a stored procedure. Thanks for your help. Ben
We are currently running SQL Server Enterprise Edition on our development server and are planning on replacing it with Standard Edition of SQL...
I believe, by default, any logins can run packages. I'd like to know how to restrict it so that only right users can run packages. I understand one...
Separate names with a comma.
