Viewing 15 posts - 1 through 15 (of 163 total)
There are two ways of handling this situation
1. Backup transaction log in between
2. Are you taking a full backup after this task? Then you can change your...
September 17, 2011 at 9:37 am
sp_configure 'max text repl size', 2097152
RECONFIGURE WITH OVERRIDE
This will set the maximum amount of data that could be transferred to 2 MB The default is 64 kb,
hope this helps
July 1, 2010 at 9:24 am
thanks for the comments. My concern is how to receive SAN information. (Hard disk capacity used. Disk health etc.)
I am actually developing an intranet to provide the data.
March 17, 2010 at 1:27 pm
The script uses SELECT DISTINCT and you can't use blog columns in comparing. It means you need to exclude them: Use the @Fields parameter to list the other...
March 12, 2010 at 9:16 pm
You say, if you don't use the date parameter query takes longer time. It means query takes the data set correctly to get the rows. So, the...
February 2, 2010 at 7:47 am
May be sending the content only when a new topic is added may be a useful thing. Later we can subscribe to the messages individually.
I dont know what is...
January 27, 2010 at 9:35 am
I receive mails on all subjects (not only threads) I have subscribed to. For example, I receive mails on "Administering"
It is different from the threads I have responded...
January 27, 2010 at 8:45 am
I felt that when we receive the mail with the message we will be more encouraged to respond.
Generally, not all can respond to all questions. Additionally, some times...
January 26, 2010 at 7:50 pm
The database serves as read only database and will not be written when SQL Server instance is running.
Like any other file backup, or registry backup, backup of these files...
January 26, 2010 at 1:35 am
Oops I just realized that this is quite old thread. I am not sure why it suddenly came into my screen.
January 24, 2010 at 11:50 pm
Removing identity property is something I have seen many people doing for some reason.
Most of the time, they perform an additional query to get the next value and then...
January 24, 2010 at 11:48 pm
GilaMonster (1/24/2010)Is google down today?http://msdn.microsoft.com/en-us/library/ms190273.aspxThere are several examples at the bottom
There are several examples at the bottom
As Google is not down, we expect you to do the search 🙂 Just kidding.
January 24, 2010 at 9:42 am
The only argument anyone can bring is in case of a failure during the middle, (which is equal to a crash I mentioned) how can you resolve it. In...
January 24, 2010 at 7:56 am
I am not sure why those statements were mentioned. I have done enough upgrades, and never went with this approach.
May be you need to send a note to...
January 24, 2010 at 7:22 am
You need to write a function which turns the multi valued char(10) column into multi rowed table.
Then you can join that table to TableB and get the values needed.
January 23, 2010 at 11:58 pm