Viewing 15 posts - 1,096 through 1,110 (of 1,270 total)
Now, you're contradicting yourself.
I wrote: "If there are two different functions with the same name but different functionality, how does SQL decide which one to use?"
You wrote: "It uses...
October 24, 2006 at 9:36 am
My mistake. My statement only applies to merge replicationn. I didn't realize until now that the rules were different for transactional and snapshot replication.
October 20, 2006 at 12:50 pm
Unless there is a work around that I am not aware of, replication is not supported between SQL 2000 and 2005 where 2000 is the publisher. In order to replicate...
October 20, 2006 at 12:02 pm
If need be, you can kill all connections to the database except yours by setting it to single_user with rollback immediate. I use this in my restore commands. Like this:
Alter...
October 20, 2006 at 11:58 am
To implement a view like that for all users, you would have to have a view for each schema being used not to mention a version of the underlying tables...
October 20, 2006 at 11:39 am
The initial question was can you specify a primary key, not how to work around it, which is part of the reasons why I didn't initially suggest any work arounds....
October 20, 2006 at 9:56 am
Or create a view that references the table in the other database and reference the view in the check constraint. There are always work arounds, but then the question becomes...
October 20, 2006 at 9:17 am
No, it's not a bug. It's the whole reason that schema's are used. It's the purpose that schemas provide. To separate objects.
As a general rule of thumb, you should specify...
October 19, 2006 at 11:58 pm
If your databases are 100% MS compliant, the only issues that I have encountered so far is that the bells and whistles are not avaialble to those specific databases. The...
October 18, 2006 at 1:56 pm
James brings up a good point. Although DDL triggers would generlly be sufficient enough, there are certain system procedures that do not fire DDL events. For example, sp_rename does not...
October 18, 2006 at 1:50 pm
In SQL 2005, you should use varchar(max) and nvarchar(max) instead of Text and...
October 18, 2006 at 12:48 pm
Well, first of all, your second command isn't even a valid command so there's no way that it would be working for you susccessfully. You can not use string concatenation...
October 18, 2006 at 12:35 pm
The Replace() function doesn't work on Text and NText fields in SQL 2000. You have to use SubString() and/or Stuff() and cycle through the column or variable changing the first...
October 18, 2006 at 12:27 pm
Well, it'll be easier in all aspects of SQL 2005, not just SSIS, because the Replace() function will work on any data type.
October 16, 2006 at 11:39 am
Viewing 15 posts - 1,096 through 1,110 (of 1,270 total)