Viewing 15 posts - 631 through 645 (of 1,189 total)
IgorMi (11/13/2012)
My answer was just one sentence, having in mind that I just started a migration process. So it matters what kind of migration you have. For example the...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 13, 2012 at 3:55 pm
GilaMonster (11/13/2012)
Before you upgrade the 2000 server, run the following:
DBCC CheckDB
DBCC CheckCatalog
If...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 13, 2012 at 3:22 pm
Lowell (11/13/2012)
Just one question, though. Why do you leave the new server unpatched until later in the migration?
it's just something i saved in my notes...i think it has more to...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 13, 2012 at 3:17 pm
GilaMonster (11/13/2012)
What are you migrating from? That's a very important point in planning.
Thanks, good point. We are migrating from two different servers into one (consolidation) -- SQL 2000 and SQL...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 13, 2012 at 3:12 pm
Lowell (11/13/2012)
there's not a lot of difference in the preperation, as compared to a full on disaster recovery plan....if the new server...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 13, 2012 at 2:32 pm
Steve Jones - SSC Editor (11/2/2012)
Check any other Windows groups that have logins for DENY permissions. NOTE that I hate...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 2, 2012 at 10:38 am
Thank you so much for this script. Is there any equivalent script compatible with SQL Server 2000?
Thanks for any help.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
October 26, 2012 at 9:28 am
GSquared (8/27/2012)
DROP TABLE permissions default to the table owner, and are not transferable. However, members of the sysadmin fixed server role...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
August 27, 2012 at 11:36 am
Perry Whittle (7/2/2012)
webrunner (7/2/2012)
From a security perspective, is it advised or discouraged for non-DBA users to have owner (db_owner or equivalent permissions) to some or all databases on a...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 2, 2012 at 12:12 pm
Hi Steve,
Thanks for the tip! That's a great idea.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 22, 2012 at 12:02 pm
Thanks, everyone, for your replies. Especially for the information about GO, which I didn't know.
I guess for now, I will make this a longer-term task with a checklist for modifying...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 22, 2012 at 11:25 am
andrew gothard (4/23/2012)
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 23, 2012 at 8:12 am
Hi,
I would like to make use of defragmentation because it sounds like it will help, but my question at this point is, is it really as simple as running Disk...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 20, 2012 at 3:28 pm
I wish I had a little Script button for my real life -- oh wait, I think that is called "memory," something I used to have more of. 😛
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 4, 2012 at 8:43 am
Thanks for your reply. I am doing the restore from the SSMS 2008 application on my desktop computer. However, the delay is still quite noticeable (5-10 seconds) when I use...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 3, 2012 at 12:50 pm
Viewing 15 posts - 631 through 645 (of 1,189 total)