As it turns out, there were some consistency and reference errors in one of the tables which was causing the DBCC CHECKDB to fail and thereby failing...
Yes we are using litespeed for the backups.
We have a database maintenance job that is scheduled to run everyday. It backs up all the databases on the server. Additionally, Performance...
We have a sql server 2000 job that invokes a DTS. A log file has been specified for the job. Now we are using ActiveX script(using...
We are using Sql server 2000. We can't use osql since it completely disrupts the formatting. Also it has a limit of 256 characters on single like....
We have a job that uses isql and executes a stored procedure. This SP contains a query in which there is a join between the table in one of the...
DB2 Transform task Error I have a DTS package that is invoked by a job that has 3 transform data tasks that connect to a DB2 server (using IBM DB2...
We have a stored proc which takes data from a database D1 (multiple tables) and inserts it into a temporary table variable. (DECLARE @Table TABLE(...
Okay, i managed to make it work <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />ISQL truncates all varchar data to 255 chars, so i...
I am using select only but still it wraps at 256 characters. I dont mind a blank line at the end of the output. I am using -n -w300 switches
I am using isql to execute a stored procedure and write the output to a file. I need the output to be on a single line. however the output beyond...
Yup. Thanks a lot for your help.
This doesnt work : This just displays the last row with a comma 789, what i need is all the rows : 123,456,789
I have a table Numbers: Nos 123 456 789 I need a query to display the output as : 123,456,789 How can this be done?
I am talking about the demo alerts that come by default . viz - Demo: Full msdb log Demo: Full tempdb Demo: Sev. 19 Errors Demo: Sev. 20 Errors Demo:...
I would like to know what could be the possible issues if i disable all the alerts(that come in by default) in Sql server. This is important since...
Separate names with a comma.
