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...

Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic627024-149-1.aspx

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...

Is the FTP succeeding? Is the file transferred completely?

Are you doing the FTP in binary mode?

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...

If your goal is to corrupt your database and cause downtime and loss of data, sure.

It is...

joshcsmith13 (12/29/2008)

---

For example, let's say I need a little help getting the correct results from my Cube operator with a Group By. This is valid syntax in 2000, 2005...

Can you check and ensure that Legato's not also doing SQL backups of...

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....

Jeffrey Williams (12/29/2008)

---

Changing the recovery model from full to simple will invalidate the backup chain - causing differential backups to fail with the error you are getting.

This could also be...

Matt Miller (12/29/2008)

---

That's the thing though - multi-posting tends to backfire here. Because so many of the regulars use the "active threads" or "recent posts" options to look at...

I'll check tomorrow. Am currently reinstalling SQL.

Please run DBCC updateusage and then run the sp_spaceused again for both the database and the table.

joshcsmith13 (12/29/2008)

---

I can't count the number of times I needed to post a T-SQL question, and couldn't decide if it should go in 2000 or 2005 to get the...

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...