Viewing 15 posts - 37,576 through 37,590 (of 39,509 total)
Agree with Andy, use DTS to move the data only. You might have to mess with it to get the parent child data to go in the right order.
Steve Jones
April 30, 2002 at 9:15 am
Brian is correct, DNS has nothing to do with Ports. DNS is a name resolution srevice. It gives back an IP for a name (and vice versa). You can specify...
April 27, 2002 at 11:20 am
the two screens are both your desktop. You configure in Control Panel | display the orientation (up/down, side to side). Your mouse then moves easily as if it were one...
April 26, 2002 at 8:37 am
Good point, though I'd be sure I had these two on another server as well. Wouldn't have done any good in this case to have them on the local drive.
Steve...
April 26, 2002 at 8:33 am
April 25, 2002 at 12:49 pm
You can use bcp and xp_cmdshell to export it.
You don't need a temp table, though that might be easier. you can make a real table and add a SPID column....
April 25, 2002 at 12:45 pm
You can use SQLAgent to do this on SQL Server.
On NT or W2K, you can schedule an ISQL query with the "Scheduled Tasks" or "At" command.
Steve Jones
April 25, 2002 at 12:44 pm
mix. I touch type, but not the "right way". In 20 years, my fingers have somewhat learned where the keys are and I can type pretty well in the dark....
April 25, 2002 at 12:43 pm
I like that. I think you should have some xx experience before you even take the test, like 1yr documented experience.
Steve Jones
April 25, 2002 at 12:39 pm
Do you have a service names MSSQL$SQL2000?
Might try re-running setup, also, I hate names like this because there might be something reserved. Can you makeup some other instance name?
Steve Jones
April 25, 2002 at 12:38 pm
I'm slightly confused as to why you need to know if the strings are longer, but that's besides the point.
If you are worried about imports, I'd make an import table...
April 25, 2002 at 12:36 pm
update mytable
set myvalue =
case
when mv_dummy = 1
then "a"
when mv_dummy = 2
...
April 25, 2002 at 12:32 pm
Are you having performance issues? Are there unexplained slow times? Jobs might help, but if not, then might not be a benefit.
Of course, it won't hurt, but then your window...
April 25, 2002 at 12:28 pm
April 25, 2002 at 11:46 am
A trigger fires once for the transaction, not for each row. So if you insert multiple rows you will have problems.
This trigger also appears that you will always get the...
April 25, 2002 at 11:44 am
Viewing 15 posts - 37,576 through 37,590 (of 39,509 total)