Viewing 15 posts - 42,106 through 42,120 (of 49,571 total)
See here for all certification info - http://www.microsoft.com/learning/mcp/certifications.mspx
To upgrade MCDBA to SQL 2008 MCITP (DB Admin), you need to first get the SQL 2005 MCITP (DB Admin), as there's not...
December 29, 2008 at 11:58 pm
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic627024-149-1.aspx
December 29, 2008 at 11:53 pm
Depends on what FTP program you're using. See it's manual/help file for how to check what mode the transfer is in.
I know the file is transfered, but that doesn't mean...
December 29, 2008 at 11:51 pm
Is the FTP succeeding? Is the file transferred completely?
Are you doing the FTP in binary mode?
December 29, 2008 at 11:09 pm
Jeffrey Williams (12/29/2008)
When you change the recovery model from SIMPLE to FULL or FULL to SIMPLE, the database is marked as *requiring* a full backup before you can perform a...
December 29, 2008 at 11:00 pm
Aspet Golestanian Namagerdi (12/29/2008)
Is it safe to work with system tables and fallowing TSQL:
If your goal is to corrupt your database and cause downtime and loss of data, sure.
It is...
December 29, 2008 at 1:51 pm
joshcsmith13 (12/29/2008)
December 29, 2008 at 1:47 pm
biniyb (12/29/2008)
But as far as File-System backups go, my SA here uses Legato which is different from NTBackup.
Can you check and ensure that Legato's not also doing SQL backups of...
December 29, 2008 at 12:26 pm
It looks like there's not enough space in the data file. To rebuild a clustered index, SQL needs at least as much space as the clustered index currently takes up....
December 29, 2008 at 12:22 pm
Jeffrey Williams (12/29/2008)
This could also be...
December 29, 2008 at 12:09 pm
Matt Miller (12/29/2008)
December 29, 2008 at 11:51 am
I'll check tomorrow. Am currently reinstalling SQL.
December 29, 2008 at 11:48 am
Please run DBCC updateusage and then run the sp_spaceused again for both the database and the table.
December 29, 2008 at 11:27 am
joshcsmith13 (12/29/2008)
December 29, 2008 at 11:25 am
May I ask why a column containing seconds would be confidential information needing encrypting? Who are you trying to protect that column against?
Look up the Encrypt functions that SQL 2005...
December 29, 2008 at 10:52 am
Viewing 15 posts - 42,106 through 42,120 (of 49,571 total)