Viewing 15 posts - 76 through 90 (of 469 total)
Test this out first, have full backups handy and also make sure you run upgrade advisor before you do the upgrade.
Thanks...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 9:20 am
You can import the packages from BI studio if there are only a few of them.
For a large number of packages, you can import the data from [msdb].[dbo].[sysssispackages] on 2005...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 8:51 am
Being on SSC, I would say use RedGate SQL Backup, which I haven't used yet but, plan to in the future.
Quest Litespeed is one good tool too, and I...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 8:07 am
You can query the INFORMATION_SCHEMA.TABLES view and see if there is a difference in the count which would mean tables having been dropped. Not sure if you can exactly pin...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 8:04 am
You can export the mdb to a text file and then use BCP from Command line
Thanks..
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2010 at 3:34 pm
Hawkeye_DBA (1/13/2010)
Virtual Server
Disk Set Data and Logs are on SASS disks (SAN) (logical partitions E...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2010 at 3:14 pm
ZeeAtl (1/13/2010)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2010 at 3:06 pm
The above code from Gsquared creates a Profiler Trace at the location specified. Also, you do not have to pass any values to the variables declared.
Just change the name of...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2010 at 1:21 pm
You can read this and this to find what's new in SQL 2008
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2010 at 9:03 am
RSage (1/13/2010)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2010 at 8:55 am
What kind of errors are you getting?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2010 at 8:29 am
OK, the article http://support.microsoft.com/kb/953200 is correct! 🙂
If you are not doing an in-place upgrade,I fail to understand how you are going to have the old databases on a new...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2010 at 8:24 am
Check if the source and destination table data types are same. Also, sometimes trailing spaces or invalid characters can cause these issues and when addressed properly, you should be able...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2010 at 8:08 am
This might help you to figure out issue
Also, check BOL for sp_repldone which might help you shrink your log
HTH...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2010 at 7:54 am
If you were to script what a Modify column in GUI is, the you would something like below.
Alter Table MyTable
Alter Column MyColumn NewSize()
When you are done with modifying the column...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2010 at 7:48 am
Viewing 15 posts - 76 through 90 (of 469 total)