Viewing 15 posts - 196 through 210 (of 1,068 total)
Kwisatz78 (6/1/2012)
... Yesterday when re-initialising our app produced an error of:Could not complete cursor operation because the table schema changed after the cursor was declared
...
Which server is throwing this...
June 1, 2012 at 9:54 pm
dan-572483 (5/29/2012)
Next, it is my understanding that SQL can restore\upgrade backups from two major...
May 29, 2012 at 10:29 pm
Did not understand the question correctly?
1) Are you asking for the steps to setup subscription to write the report to a folder?
2) Are you saying Std Ed does not have...
May 24, 2012 at 3:06 am
No need to restart the instance to shrink the file.
Have you tried dbcc shrinkfile?
Also run dbcc opentran to see whether there is any open transaction.
May 24, 2012 at 2:47 am
You can use the method mentioned here:
How to transfer logins and passwords between instances of SQL Server
May 23, 2012 at 11:44 pm
Lexa (5/23/2012)
Followed by a bunch of these:
"Error: 10982, Severity: 16, State: 1.
Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID...
May 23, 2012 at 11:19 pm
shubhamagrawal.107 (5/23/2012)
please tell any one , how i see the query which is used for creating a table
SQL Server does not keep the query used for creating a table.
But you...
May 23, 2012 at 1:24 am
k.subramanyam1017 (5/21/2012)
could u please any one tell me the these questions
1) what is your company file architecture and how much data u r handle.
2) how...
May 22, 2012 at 11:59 pm
saidapurs (5/22/2012)
Hi,Yes, i have sysadmin rights (using 'sa' account)...
Not sure why LS/Mirroring not appearing.
Anyway try this and see what happens:
1) Check the properties of some other...
May 22, 2012 at 10:38 am
It is possible.
Could you explain the steps you are trying to configure LS.
Where are you not seeing this future?
May 22, 2012 at 12:26 am
jude.pieries (5/21/2012)
Let me clear out the mismatch of words, I want to move the system database from one drive to another, the MASTER db was moved...
May 21, 2012 at 11:37 pm
jude.pieries (5/20/2012)
I have detached the system databases and attached the master database but the models database won’t get attached.
Msg 7940, Level 16, State 1, Line 1
System databases master, model, msdb,...
May 20, 2012 at 10:35 pm
By default jobs run under SQL Agent account.
However, Proxy account can be used to run an SSIS package.
Open the job step and see what is there under "Run As".
May 20, 2012 at 10:06 pm
sukhoi971 (5/18/2012)
there are 100s of tables
if i take backup and then delete the database will it improve perfomance?
since...
May 18, 2012 at 4:56 am
Viewing 15 posts - 196 through 210 (of 1,068 total)