Viewing 15 posts - 706 through 720 (of 5,103 total)
On SQL Server 2000 CHECK CONSTRAINTS were enforced "BEFORE" the insert actually took place apparently on 2005+ there are issues with this as you have already verified. There are several...
January 14, 2009 at 10:01 am
If I were to get a penny for every problem I have been called to "solve" regarding "I forgot to highlight the WHERE clause (or part of it)" I...
January 13, 2009 at 3:24 pm
ganeshmuthuvelu (1/13/2009)
A CDE
Notice the space between the...
January 13, 2009 at 3:09 pm
sqlserverdba76 (1/13/2009)
Thanks for reply..well i already tried replication without delete...just wondering if there any other solution.
anyway still thanks...
And what is the problem with that ?
January 13, 2009 at 2:50 pm
It is not if you can ping it, It is that your connection to the server is not "stable" for some reason. You should check the monitored server for load...
January 13, 2009 at 2:49 pm
TRACEY (1/13/2009)
When setting up the linked server.
provstr 'Integrated security=SSPI"
SQL SERVER1 (Use domain\tracey)
MYFIRSTDB
...
January 13, 2009 at 2:05 pm
What is the frequency of your Transaction log backups ?
I bet you are experiencing autogrows!
January 13, 2009 at 1:48 pm
Be careful not to give the account that run that stored procedures more privileges than "read" or you still may be surprised! 😉
January 13, 2009 at 11:42 am
You should check two things.
1. Verify that the source data is actually NULL and not an empty string.
2. Verify that the destination column does NOT has a default value...
January 13, 2009 at 11:39 am
If you don't care about "fancy" features like Partitioning, Database Snashots, Online-index rebuilt among others you are probably fine.
Given the transaction rate you are posting "standard" maybe ok. How...
January 13, 2009 at 11:34 am
Any chance to revisit your assumptions and design? any table with 1000 columns sounds rather denormalized to me.
You are being NICE ... any table with 1000 columns is...
January 13, 2009 at 11:30 am
Follow the link I posted for tablediff or use our good old friend google, there are many articles on the web with examples on how to use tablediff.
From your...
January 13, 2009 at 11:26 am
MarkusB (1/13/2009)
Gaby A. (1/13/2009)
MarkusB (1/13/2009)
January 13, 2009 at 11:17 am
Linked SQL servers tend to not like ".." you should try the post above where it is correctly specified as ".dbo."
January 13, 2009 at 11:09 am
Something is killing your connection from the monitor. You should check the network and any other component that maybe doing that.
January 13, 2009 at 11:05 am
Viewing 15 posts - 706 through 720 (of 5,103 total)