Viewing 15 posts - 1,126 through 1,140 (of 1,319 total)
Not a problem. I thought maybe you were calling SQL ORACLE out for a challenge! I don't have any issues here with duplicates. I just thought if you already had...
-- You can't be late until you show up.
May 23, 2008 at 9:23 am
Are you having issues with your disk drives where the backups are being written to? You may want to check perfmon or profiler for I/O metrics (or disk manager) or...
-- You can't be late until you show up.
May 23, 2008 at 7:53 am
Jeff Moden (4/29/2008)
SQL ORACLE (4/29/2008)
You cannot delete duplicates directly from a table unless you would like to delete rows, which are duplicated.Any bets? 😉
Jeff, I am not doubting your ability...
-- You can't be late until you show up.
May 23, 2008 at 7:19 am
I won't define the topics as that has already been taken care of but I will add my 2 cents, for what it's worth.
1) Truncate - if you truncate the...
-- You can't be late until you show up.
May 23, 2008 at 7:06 am
Mapped drives will never work. UNC paths are the only way to do it. I have used a remote server exclusively for my backups without any issues. There are plenty...
-- You can't be late until you show up.
May 22, 2008 at 6:55 am
It all depends on what you need to do. Here is a link to side-by-side comparisons of the paid version and freeware (paid is relatively inexpensive!). You can't do encryption,...
-- You can't be late until you show up.
May 22, 2008 at 6:44 am
Run the following to see if it returns anything. If it does, you have an index by that name! I'm assuming SQL2K. Let us know what you see.
select *...
-- You can't be late until you show up.
May 21, 2008 at 1:51 pm
The infamous cross-post!!:angry:
http://www.sqlservercentral.com/Forums/Topic504585-357-1.aspx
-- You can't be late until you show up.
May 21, 2008 at 1:38 pm
And charge them accordingly!!:Whistling:
-- You can't be late until you show up.
May 21, 2008 at 1:29 pm
Where and how are you running this? If through SQL Server Agent, the account running the agent should have rights to the data share. You won't have to pass any...
-- You can't be late until you show up.
May 21, 2008 at 1:21 pm
Steve Jones - Editor (5/21/2008)
Consistency != inflexibility
Hasn't != been deprecated???:D And I agree wholeheartedly, evolution is inevitable. As long as it's handled properly, it can/will be a wonderful thing!
-- You can't be late until you show up.
May 21, 2008 at 8:53 am
Ah, one of my favorite subjects, backups. What you should be doing is what your business/SLA wants you to do. How much data loss can you tolerate, an hour, a...
-- You can't be late until you show up.
May 20, 2008 at 2:50 pm
In query analyzer, run Select @@version. It'll display version numbers which you can check here to determine your level.
http://support.microsoft.com/kb/321185
-- You can't be late until you show up.
May 19, 2008 at 12:09 pm
Sorry, I mis-understood the intent or your original post as that will script all your users from one server to another. Did you try: sp_change_users_login 'username', 'AUTO_FIX'? Run this within...
-- You can't be late until you show up.
May 19, 2008 at 11:57 am
GSquared (5/19/2008)
Crever, I've got maintenance plans that have been running smoothly since I set them up in September,...
-- You can't be late until you show up.
May 19, 2008 at 11:52 am
Viewing 15 posts - 1,126 through 1,140 (of 1,319 total)