Viewing 15 posts - 301 through 315 (of 498 total)
I've never thought about this. However the diagram is stored in the dtproperties table so I would assume the user would at the very least need to have the ability...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 17, 2003 at 6:44 pm
Before adding a table I would make sure that you have all your subscriptions sync up. Then add the table. The reason for this is that you will have to...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 17, 2003 at 6:36 pm
the best way would be to add an identity column to the table so that when you import the data you can preserve the ordering. Then use an order by...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 4, 2003 at 11:04 am
I'm changing to uniqueidentifiers because I'm tired of dealing with the managed identities. I have had to repair data every month since I started working on this database for the...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 4, 2003 at 11:02 am
If you add the NOT FOR REPLICATION to the identity columns you can then create a script to run before the snapshot is applied that creates the schema. Then run...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 3, 2003 at 7:37 pm
If you are concerned with the way the data is ordered when you retrieve it then use an order by clause in the select statement. You can NEVER garantee that...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 3, 2003 at 7:26 pm
Yikes,
First you will need to create a script to script out the tables. Then you will need to rename all the tables to a new name, modify your script to...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 3, 2003 at 7:19 pm
In my experience I usually just drop the subscription and recreate it in EM. But then, I'm lazy when it comes to the Snapshot replication.
Or you can use EM...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 3, 2003 at 7:04 pm
Since you don't state what your PK is this is a little hard to do. But I would create a script that will set the rowcount to 1000 and then...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 3, 2003 at 6:19 pm
The best way I can think of is to check for the error before the insert and then manually roll back and then log the error.
Gary Johnson
Microsoft Natural Language Group
DBA,...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 30, 2003 at 7:48 pm
Can you check with Profiler what is going on? It sounds like you are having a problem with not getting the transaction committed.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 30, 2003 at 7:41 pm
You need to take a look at SQL Server Books Online on the Restore command.
basically
Restore Database <dbname>
FROM DISK = 'filename'
WITH STATS, MOVE...
I don't have BOL here so I can't...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 29, 2003 at 11:13 pm
Check your ANSI_NULLS setting. Usually you will want to use the ISNULL function instead though. That way regardless of how the database is set up the code still works.
IE:...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 29, 2003 at 3:54 pm
I would simply create an error log table and put your errors in it (make sure to roll back transactions BEFORE writing to the log table!), use something like xp_cmdshell...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 29, 2003 at 3:47 pm
Here is a SP that I use quite a bit. Please use it with caution and make sure to double check the output text to verify that it's correct.
The...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 29, 2003 at 3:37 pm
Viewing 15 posts - 301 through 315 (of 498 total)