Viewing 15 posts - 46 through 60 (of 683 total)
When the server name was changed was the SQL Server name also changed? If not you must first change the SQL Server name like so:
exec sp_dropserver ''
exec sp_addserver '',...
June 25, 2009 at 2:10 am
This isn't so much of an issue but a feature of the truncate command. Because truncate is not a fully logged operation it doesn't check for referential integrity so...
June 11, 2009 at 5:07 am
This sounds a bit like a school work type question so without wanting to give too much of an answer I'd suggest you look at the GROUP BY clause -...
June 11, 2009 at 4:59 am
shanikasuwaris (5/11/2009)
i posted this same question on another forum and came across the following article. according to that full backups break the backup sequence of log shipping.
That...
May 12, 2009 at 12:58 am
log shipping is unaffected by full/differential backups.
May 11, 2009 at 8:55 am
Florian Reischl (5/10/2009)
DBA:
Usually this works fine. Sometimes there stay some "dirty bytes" within the t-log after the index rebuild(s) and the t-log backup (after the index rebuilds) will not...
May 11, 2009 at 8:50 am
The solution is provided for you in my first post but, as I mentioned, this is a bad idea and I seriously advise against it. You still haven't explained...
April 16, 2009 at 12:46 am
You can use sp_configure to set the 'user connections' configuration option to limit the server to a maximum of 20 users although I can't think of why you'd ever want...
April 15, 2009 at 7:08 am
If there isn't a unique id between the first course meals and the second course meals you'll need to create one. Without one there's nothing to tell you that...
April 15, 2009 at 5:28 am
Nicholas Cain (12/23/2008)
Just curious, were the filegroups on different drives? I'm not exactly sure how the partitioning works, but if you have...
December 23, 2008 at 9:53 am
I've figured out a quicker of doing what I wanted. So for those that are interested:
I switch partition 1 into a table called [table_old_data]. I then switch partition...
December 23, 2008 at 8:39 am
Perry Whittle (11/20/2008)
what columns does the table have?which column(s) were you thinking of creating the index on?
I can't remember off the top of my head the list of all the...
November 20, 2008 at 3:46 pm
rajdba (11/6/2008)
:)Your Customers says to start a new production Server at 9:00 AM.
:)You started your production servers at 9:00 AM.
:)Transaction Started.
:)Database is in Full Recovery...
November 6, 2008 at 3:42 am
There's only one thing I find scarier than a cursor, and that's a cursor that is used inside of a trigger.
Trust me, you do NOT want to go down this...
November 5, 2008 at 9:56 am
have a look at sp_start_job in books online.
November 5, 2008 at 9:50 am
Viewing 15 posts - 46 through 60 (of 683 total)