Viewing 15 posts - 3,106 through 3,120 (of 6,216 total)
I can duplicate it with MDAC 2.6 and 2.7. Running the sql it builds up in QA works fine, you get one row. Each time you run via the code...
October 8, 2002 at 6:07 pm
October 8, 2002 at 5:59 pm
Do you have space free on the server? Are you replicating the db? If you are and the log reader fails you wont be able to clear transactions from the...
October 8, 2002 at 7:27 am
Glad you figured it out. For blocking, look at a cursor that queries against sysprocesses to see what is blocked/blocking. Might have something in the script library already.
Andy
October 8, 2002 at 7:26 am
You can also configure an alias using the client utility.
Andy
October 8, 2002 at 4:23 am
Soundex is decent for this. Not great, but built in and worth considering. What we do is preprocess the columns to remove "noise" words like company, corporation, co, etc, plus...
October 8, 2002 at 4:21 am
For pure TSQL (is there such a thing?) you can use sp_oacreate to use the file system object or a recordset object to write to disk. DTS offers the same...
October 8, 2002 at 4:18 am
Commenting has out has its place, sometimes anything else is overkill. What case do you make for scripting out all the db objects?
Andy
October 8, 2002 at 4:13 am
I dont think role membership matters. Do you already have users in the db you're transferring too? If so you need to remove them or just not move them the...
October 7, 2002 at 1:48 pm
Post as often as you like.
#1 - Anything that can open an ODBC or OLEDB connection, there is a JDBC driver too.
#2 - Assuming you have one of the...
October 7, 2002 at 1:46 pm
Using NT or SQL logins? Using the Copy DB Wizard or actually DTS'ing the tables?
Andy
October 7, 2002 at 10:39 am
Same query plan may not be appropriate depending on the data distribution. You could add the recompile switch to see what happens. You'll take a small perf hit each time...
October 7, 2002 at 10:38 am
Two thoughts. One is that identical query plans may not be a good thing? The other is whether or not you've confirmed there is no blocking? Make that three -...
October 7, 2002 at 5:44 am
Really nothing to worry about with any of those. Do a good backup first, then upgrade. As easy as it gets.
Andy
October 7, 2002 at 5:42 am
The other issue for #2 may be time. Depending on drive size, network speed, etc, it might be faster to do the backup/restore rather than copying the mdf across (or...
October 7, 2002 at 4:24 am
Viewing 15 posts - 3,106 through 3,120 (of 6,216 total)