You can restore your Full Backup as a different name, and insert the data back into your empty table from the backup with a insert into (select ....) statement.

You'll need to consider buying space in a Cloud, using SQL Azure.

look here: http://www.microsoft.com/en-us/sqlazure/default.aspx

Thanks for ur reply..

I am able to design ssrs report in local system...while deploying , URL not found error is coming..... i tried lot of times

in my local system (http://localserver/reports)......

Yes, Disabled is different from Locked.

SELECT LOGINPROPERTY('loginname', 'IsLocked') is also my guess.

I think if the...

They are able to export it to PDF and printing from PDF works fine. When they are print directly from the report it is not printing. any suggestion or ideas...

Thanks for a very basic, but extremely valuable article Steve.

I manage a group of DBA's from Oracle to Postgres etc...and find a lot of different writing styles and different approaches...

jaffrey (1/10/2011)

---

Hai to all,

I am working as sql server developer in a concern but i am very interested to learn SQL server DBA as well,I have no idea about...

brainblower13 (1/10/2011)

---

Hi,

I Dont have Local server Reporting Services in my machine. I try To Connect the Remote Desktop of Server System . I configured needed Connections for Remote Desktop...

You are trying to connect from 32bit to 64bit drivers or 64bit to 32 bit.

Make sure the DSN you create is present in both the 64 bit and 32bit ODBC's.

Add...

Here is the official page and all info needed.

http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

they are the same....

Dave explains is very nicely...

http://blog.sqlauthority.com/2007/09/13/sql-server-difference-between-exec-and-execute-vs-exec-use-execexecute-for-sp-always/

Is this query is SQL or VB?

in SQL you might find a: Select @x from..... if @x was declared as a variable.

but normal Select x .... means X is your...

Use your local computer name as the servername, or a "." <- dot...since it's installed as the default instance.

Post the error you receive.

http://technet.microsoft.com/en-us/library/ms143799.aspx

might be of some help.

Disk Space

Blocks

Long running queries

IO's of all platforms

Outdated backups

Job Failures

Excessive failed logins (hack attempts)