Viewing 15 posts - 4,051 through 4,065 (of 6,216 total)
Even if you do have a program that expects it to be in a certain ordinal position, you can fix that usually by changing the name of the table and...
June 10, 2002 at 10:55 am
Dont think you can. Even using EM it will bcp the data out, change the structure, bcp it back in - if you're changing column order. Why do you care...
June 10, 2002 at 9:25 am
In the sql error log. Its a big chunk of info, BOL has some info on deciphering it.
Andy
June 10, 2002 at 9:24 am
Are you likely to have a problem with the 3rd party app? If you have to validate at the text file level, I dont see a way of doing it...
June 10, 2002 at 7:45 am
How about loading it into a working table nulls and all, then you can use a single select to identify all the bad rows, or just exclude them when you...
June 10, 2002 at 7:10 am
The easiest way I've found is to use sp_stop_job to stop the job that called the agent rather than trying to stop the agent itself.
Andy
June 10, 2002 at 7:09 am
I dont think learning VB6 or ASP3 would be a waste of time, there is a LOT of code out there written in both. Thats good since you may end...
June 10, 2002 at 4:39 am
I sorta see your point, but ultimately what you dont have is a current backup, which to me is a far greater problem!
Andy
June 10, 2002 at 4:34 am
You can do it easily in SQL2K by declaring the foreign key relationships and enabling cascading deletes. In earlier versions (or even SQL2K if you prefer to do it manually)...
June 8, 2002 at 5:55 pm
I paused my service, then ran it, got the error:
-2147023174 [SQL-DMO]Service Control Error: The RPC server is unavailable.
Trying again with service stopped:
Error : -2147221504-[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does...
June 8, 2002 at 5:52 pm
That will happen automatically unless you enable recursive triggers, which is disabled by default and not likely to be needed!
Andy
June 8, 2002 at 9:07 am
June 7, 2002 at 9:39 pm
Coalesce could be used in place of isnull, and BOL points out that it can be used instead of a case statement. I think for ease of understanding if you're...
June 7, 2002 at 8:19 pm
You change it in the distribution properties in EM, part of replication from the main menu. You can change the password directly in the job step for the distribution agent...
June 7, 2002 at 8:17 pm
From BOL:
A local temporary table created in a stored procedure is dropped automatically when the stored procedure completes. The table can be referenced by any nested stored procedures executed by...
June 7, 2002 at 8:08 pm
Viewing 15 posts - 4,051 through 4,065 (of 6,216 total)