Hello, I have source table with columsn, Flight ID , Starting From , Destination. I bring them to a flat file ( i.e to a text file) and then...
hello I am trying to create a package. I am executing the query select * from db; in the sql query and sending the result to test. While using the...
Hello, I have got a query , which gives the constraints in a database. select A.TABLE_SCHEMA, A.TABLE_NAME,A.COLUMN_NAME, A.CONSTRAINT_NAME,...
Hello, Yestarday night we had a log backup failure at 3.00 AM on a sql server 2000. After that the hourly log backup's went on smoothly. When I...
Hello, How can I recycle the sql server error log file and specify the retnetion period. I can use sPp_cycle_errorlog. How can I specify the size...
Hello I have two tables PROJECT ( with columns PROJECT_ID , TL , FL , PM )and PROJDATE(with columns PROJECT_ID , delivery_date, Delivered_date). The...
Hello, I have a query in sql server 2000 , which I should make it work in MS access 2003. Can anybody help me out in coverting the below query....
hello, Is there any SQL Proc ,to identify long running queries. I have been getting low memory alerts. So wanted to check for any long running...
Hello How can I mount a database in sql server 2000. I was not able to take offline.I am not sure..what happened to the db , it shows me suspect for...
Hello, I have the following query which I actually run in the MS-Access to get the result.But it was not returning any rows , so I am testing in SQL...
hello, In one of the database name X , one table by name resources was lost. so I brought back the old backup of the database from the tapes . I...
Hi All, I wanted to know if there any any recommended values for the SQL Server and Database parameter values settings. On our servers , no...
Hello This might be a basic question. How can find out the number of CPU's used by the SQL Server. Thanks
Hello, I am running the SQL Profiler on the sql server 2000. It doesnot show the values of DBusername , DBname and NTuser name. What should I do for...
Hello , I would like to monitor all my SQL Server's for there , Memory Usage , CPU Utilization , Disk I/O ,User connections and any blocks. How can...
Hello , I want to truncate the T -log file every weeekend. I want to know if my plan is right. I have T - log backups from 7.00 am till 9.00 pm...
Hello, I am trying to figure out if we want to implement replication in SQL Server 2005 does it require licensing. I have got information on BOL...
Hello I am trying to install client tools on my desktop and I am getting the following error : Edition Change Check (Warning) Messages Edition...
Hello I have maintenance plan that takes backup of log file and db every night. when I am trying to T-Log backup every one hour , the job is...
Hello In my maintenance plan of 2005 , I have the Re-organize Index everynight . And in the morning I see the T-Log has grown huge. Does the...
Separate names with a comma.
