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...
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...
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...
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...
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...
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,...
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 *...
May 21, 2008 at 1:51 pm
The infamous cross-post!!:angry:
http://www.sqlservercentral.com/Forums/Topic504585-357-1.aspx
May 21, 2008 at 1:38 pm
And charge them accordingly!!:Whistling:
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...
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!
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...
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.
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...
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,...
May 19, 2008 at 11:52 am
Viewing 15 posts - 1,126 through 1,140 (of 1,319 total)