Viewing 15 posts - 571 through 585 (of 1,079 total)
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.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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)......
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 6, 2011 at 2:58 am
http://technet.microsoft.com/en-us/library/ms143799.aspx
might be of some help.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 6, 2011 at 2:45 am
Disk Space
Blocks
Long running queries
IO's of all platforms
Outdated backups
Job Failures
Excessive failed logins (hack attempts)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 6, 2011 at 2:13 am
Viewing 15 posts - 571 through 585 (of 1,079 total)