Viewing 15 posts - 61 through 75 (of 112 total)
It sounds like a permission problem with the user account that you are using to run the Upgrade Wizard .
May 11, 2006 at 8:57 am
Macca:
In Management Studio: If you right-click on the table you want to modify, and choose "Modify":
* You should be able to select more than one field for a primary key...
May 11, 2006 at 8:54 am
If you are starting to have doubts about hiring a person after you interviewed them you can always try:
(1) calling references to get a feel for the candidate's personality (you would be surprised...
May 4, 2006 at 6:17 am
In SQL 2005 EM,
to find the maintenance plans: (DB_SERVER) -> Management -> Maintenance Plans
to find the scheduled jobs: (DB_SERVER) -> SQL Server Agent -> Jobs
** replace (DB_SERVER) with the...
May 4, 2006 at 6:03 am
Not sure if this is what you are asking ... in FULL recovery mode when you perform a transactional log backup, your transacation log file will be reduced in size...
May 2, 2006 at 7:09 am
What a great idea! I can't wait to see your course offerings. I only hope that I can persuade my boss to send me to a class in Orlando, Fl...
April 26, 2006 at 1:23 pm
I use the "Remove Files Older Than" option in my maintenance plans. For example, my maintenance plan #1 writes all backups to C:\Backups and runs every Sunday. ...
April 21, 2006 at 1:14 pm
Found the following at http://msdn2.microsoft.com/en-US/library/ms186865(SQL.90).aspx. It seems to be that the difference is that "EXPIREDATE" gives you the option of specifiying the ACTUAL DATE the backup can be overwritten while...
April 21, 2006 at 7:14 am
We do not use screen shots. Having them in the documentation just causes more work when upgrades are made to the software. If you have a minor upgrade where there...
April 20, 2006 at 5:33 am
Glad that helped. Sorry though, I don't know the answer to:
April 7, 2006 at 9:39 am
Just tried this out. In the SQL Export Wiz, on the "Select Source Table and Views", click the "Edit" button next to the table that contains a varchar. Change the...
April 7, 2006 at 6:52 am
I am glad that I am not the only one who had that question ... I was so curious about it that I saved the icon (from my browser) to...
March 31, 2006 at 6:00 am
Top 10 differences between SQL Server and Access:
10) Memory management
9) SQL can handle bigger size databases
8) Extra server side components for SQL Server (i.e.like Analysis services, DTS, etc)
7) You can...
March 30, 2006 at 6:34 am
March 28, 2006 at 7:14 am
As SQLBill mentioned, make sure that SQL Server Agent is running:
On the server, open up Control Panel -> Administrative Tools -> Services. Make sure that "SQLSERVERAGENT" is listed as "Running". ...
March 22, 2006 at 6:52 am
Viewing 15 posts - 61 through 75 (of 112 total)