Search Results | SQL Server Performance Forums

SSIS on 2 nodes cluster

Thread by: shabnyc, Jun 23, 2010, 19 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I am new to cluster environment. we have 2 nodes cluster active/passive, we have an SSIS package in the virtual node. the package should run...

Transferring table content into flat file using DTS

Thread by: shabnyc, Dec 24, 2008, 5 replies, in forum: General DBA Questions

Hello, How is everyone doing in this great site!. I have a DTS package that runs selecting data from a SQL DB and copy them to a flat file in a...

Query took 5 minutes to run, now is taking forever.

Thread by: shabnyc, Nov 21, 2008, 6 replies, in forum: General DBA Questions

Hello, how is everyone doing? this qury below used to take 5 to 10 minutes to execute. it has been like this as developer said for 2 years. Now it is...

Error on the SQL server,

Thread by: shabnyc, Nov 14, 2008, 3 replies, in forum: General DBA Questions

Hi all, one of the SQL 2000 servers we have keeps giving this error( An error occurred on line 2185 while executing script 'SQL Server 2000 Space...

How to Run query from batch file and get the output into batch variable

Thread by: shabnyc, Jan 31, 2008, 13 replies, in forum: SQL Server 2005 General DBA Questions

Hi guys, I really need help on this because I couldnt find any info on this issue online. I need to run the following 2 queries from within a batch...

How to query the default data and log file location

Thread by: shabnyc, Jan 25, 2008, 7 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I am trying to query the default location of data and log files in a SQL server instance through an SP. can anyone help in providing the...

Urgent .. Need to combine 2 SQL files into one using sqlcmd

Thread by: shabnyc, Dec 12, 2007, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I have to sql files (1- dropstatement.sql), (2- createstatement.sql). I need to use sqlcmd to create a new .sql file (3- allstatements.sql)...

Script Function using Stored procedure

Thread by: shabnyc, Aug 23, 2007, 19 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I need to write an SP that script each user defined function with its permessions, and put this code (with the permissions) in an SQL file. the...

Urgent: Need script to compare Log size to datafile size

Thread by: shabnyc, Jul 31, 2007, 13 replies, in forum: SQL Server 2005 General DBA Questions

Hi everyone, I am looking for a script that check the log files for all DBs in an SQL server and compare the size of log to the size of datafile. If...

Getting weird result when sending @query alert

Thread by: shabnyc, May 20, 2007, 7 replies, in forum: SQL Server 2005 General DBA Questions

Hi guys, I am trying to send an email if full backup MP failed. I included the following script in the job step that alert me when the MP fails....

Maint Plan and Backup failure Question

Thread by: shabnyc, May 3, 2007, 7 replies, in forum: SQL Server 2005 General DBA Questions

Hi everyone, I have a maint plan that take backup of all DBs in our system. when a backup of a DB fails alerts dont work sometime. I am used to...

How to search for a column and create index

Thread by: shabnyc, Apr 18, 2007, 15 replies, in forum: SQL Server 2005 General Developer Questions

Hi all, In a stored procedure (may include Cursor), I want to search for a column ColumnName in a SQL database that has 5000 tables. In each table,...