Viewing 15 posts - 571 through 585 (of 1,081 total)
Can i restore the prod db backup (SQL 2000 Ent) to Dev Box ( SQL 2000 Std).
If both SQL Servers are on the same level version, yes.
If your source SQL...
January 11, 2011 at 12:24 am
you can only recover back to the last data that you backed up.
January 10, 2011 at 11:44 pm
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.
January 10, 2011 at 11:23 pm
You'll need to consider buying space in a Cloud, using SQL Azure.
look here: http://www.microsoft.com/en-us/sqlazure/default.aspx
January 10, 2011 at 10:43 pm
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)......
January 10, 2011 at 2:27 am
Generate the report but give the informatio as is_disabled. But I think is_disabled <> is_locked.
Yes, Disabled is different from Locked.
SELECT LOGINPROPERTY('loginname', 'IsLocked') is also my guess.
I think if the...
January 10, 2011 at 1:59 am
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...
January 10, 2011 at 1:41 am
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...
January 10, 2011 at 1:31 am
jaffrey (1/10/2011)
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...
January 10, 2011 at 1:23 am
brainblower13 (1/10/2011)
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...
January 10, 2011 at 1:19 am
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...
January 10, 2011 at 1:05 am
Here is the official page and all info needed.
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx
January 10, 2011 at 12:10 am
deepikamm (1/6/2011)
what is the major difference between EXEC and sp_executesql?
they are the same....
Dave explains is very nicely...
January 6, 2011 at 4:02 am
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...
January 6, 2011 at 3:58 am
Use your local computer name as the servername, or a "." <- dot...since it's installed as the default instance.
Post the error you receive.
January 6, 2011 at 2:58 am
Viewing 15 posts - 571 through 585 (of 1,081 total)