Viewing 15 posts - 37,621 through 37,635 (of 39,509 total)
most people only send mail, they do not receive it. If you do this, there is no virus infection. If you read mail, I believe Antares is correct, but I...
April 17, 2002 at 3:59 pm
Log things from teh DTS pacakge. Either use the logging of the tasks, of write an ActiveX task to help.
Then run findstr from your batch file on the log file...
April 17, 2002 at 12:46 pm
In a similar situation we added a column to tables that need logging and insert/update this column with the userid from the sproc. If this column is not updated or...
April 17, 2002 at 12:45 pm
Can you backup to disk? Try a simple backup of master to disk and see what happens.
If this works, try a manual backup of master to tape and see what...
April 17, 2002 at 12:42 pm
Agree with Jordan. I don't like running this on servers for a variety of reasons. Set a strong administrative policy that people should not be running browsers, etc. on servers,...
April 17, 2002 at 12:38 pm
Agree with jgee. I import into a table that duplicates the setup on the main table.
Then I update the main table from the import using the PK as a match...
April 17, 2002 at 9:18 am
Have you logged in as the sql server account and successfully sent mail using iNotes? Be sure this profile is the default profile and Outlook is not set to ask...
April 17, 2002 at 9:12 am
Just like multiple physical disks enhance performance, multiple controllers can as well because the load can be spread.
I agree with Andy' suggestions and don't know which is best. Compaq and...
April 17, 2002 at 9:06 am
That CD is the media for the license you got when you purchased your computer. If you still have XP on the computer, then you cannot install it elsewhere. If...
April 17, 2002 at 8:59 am
April 16, 2002 at 1:21 pm
Not sure about this one, but there were lots of changed to OLAP in SQL 2000 and I suspect the DTS task changed. Not sure if you can automate a...
April 16, 2002 at 9:58 am
In Oracle there is always a cursor created and referred to for operations. Something I did not know until recently and it seems lots of people coming to SQL Server...
April 16, 2002 at 9:55 am
April 15, 2002 at 4:00 pm
backup restore or detach/attach are both easy. I'd do the detach/attach if this is a one time thing.
Steve Jones
April 15, 2002 at 3:58 pm
I would say that a DBA is responsible for the integrity and performance of the database. Therefore the DBA should do all object and query development OR review all queries...
April 15, 2002 at 3:56 pm
Viewing 15 posts - 37,621 through 37,635 (of 39,509 total)