Viewing 15 posts - 3,496 through 3,510 (of 7,429 total)
If you are wanting to push only changes then snapshot is out but it will be used on the initial push either way. So you are left with merge (which...
January 23, 2003 at 4:40 am
Ahh. Sorry that is not possible. You have two modes of authentication, NT or Mixed (SQL and NT). EM can be used by either one but they still only have...
January 23, 2003 at 4:27 am
First off renaming can and will affect any trigger, view, SP or other tiem referencing it so it is not recomended to do a bulk of them without first backing...
January 23, 2003 at 4:03 am
Ant2001 can you post the table DDL and and idea of the package of a situation where the problem is occurring. I have several packages myself but none fail. I...
January 23, 2003 at 3:51 am
You can also do
IF OBJECT_ID('tblname') IS NOT NULL
but the IF EXISTS method is MS standard way.
January 22, 2003 at 6:41 pm
You should test beforehand to decide if you need or don't. You can however change afterwards if needed.
Do a search in SQL BOL for
"cross database ownership chaining"
and you will turn...
January 22, 2003 at 5:19 pm
Walk us thru your link server setup and the code you are actually using.
January 22, 2003 at 3:31 pm
There is a lot of confusing things going on here. Like why do you keep doing Ltrim(Rtrim( the data has no spaces in it or on front or end?
Also, when...
January 22, 2003 at 3:29 pm
Yes to all of the above. Usually you can set these things when you register a server. But if you need to do afterwards then open EM, drill to the...
January 22, 2003 at 3:13 pm
Ah, good someone on the Beta who saw this. Sorry I did like 20 test installs under various conditions I may see and never hit this one. Hope Davids on...
January 22, 2003 at 3:10 pm
I was doing with SQL 2K on Windows 2000 and XP both give same result. I will have to test with the 7 but don't have it running on an...
January 22, 2003 at 3:08 pm
Ok then again what about multiple instances?
And what is the name of the package file you downloaded? Are you sure you grabbed the right one (should bark this but...)
Have you...
January 22, 2003 at 12:54 pm
I found the reason why is that you cannot specify whether or not the identity column is included in the Import Data task. Because of this it is expecting a...
January 22, 2003 at 12:35 pm
I don't think they are talking DTS folks. I tried and DTS is fine. It is the import/export wizard under tasks that fails on this just like they state. I...
January 22, 2003 at 12:24 pm
Ok sitting at the server. Have you tried to log in with the SA credentials or a trusted account with QA or EM to verify if there is an underlying...
January 22, 2003 at 12:07 pm
Viewing 15 posts - 3,496 through 3,510 (of 7,429 total)