Viewing 15 posts - 166 through 180 (of 279 total)
Now you have a different error, like the message state you have a syntax error in xml passed to sp_xml_preparedocument.
April 23, 2013 at 1:02 am
If you can change the recovery mode to simple for a maintain purpose, you can try this:
- recovery mode to simple
- full db backup
- shirink log to proper size
- recovery...
April 20, 2013 at 11:48 am
If this is an issue for you, you could try a bulk logged first. But remember that this make a backup process more complicated and what if eg. a script...
April 20, 2013 at 11:29 am
Fraggle-805517 (4/19/2013)
....
....
BEGIN CATCH
<<...
April 20, 2013 at 10:55 am
...an excerpt from the book with explanation the short-circuit and the all-at-once concept :
April 19, 2013 at 4:00 am
T.Ashish (4/18/2013)
....Why I/O Statistics are same for both the above queries.
Try on bigger one and with bigger difference in selectivity. Probably 112 rows reside on 7 pages and 107 rows...
April 19, 2013 at 1:41 am
Try this: http://support.microsoft.com/kb/891984
April 18, 2013 at 2:16 am
Probably the point 3 is an issue "Check if the account which is trying to access the database has enough permission to perform operation." if not check other points
April 6, 2013 at 5:40 am
EFS in Windows is connected with user (only user has acces to certificate to decrypt data). This should still be valid for 2008 http://www.mywebhostingblog.net/aspnet-web-hosting/secure-ms-sql-2005-database-with-efs-encryption/
April 4, 2013 at 4:35 am
winmansoft (4/2/2013)...
If a user has admin permission then he can alter the symmetric key using alter SYMMETRIC KEY command and change password. So he can decrypt the data then easily.....
No,...
April 2, 2013 at 12:13 pm
winmansoft (4/2/2013)
April 2, 2013 at 7:06 am
Check this http://mssqlwiki.com/2012/10/16/sql-server-exception_access_violation-and-sql-server-assertion/ there is a basic knowledge how to debug a dump file
March 28, 2013 at 5:46 am
It's the Database!!! (3/19/2013)
e4d4 (3/14/2013)
And what are in the first line of Summary.txt file?Should be:
Overall summary:Final result: ....
Sorry I have been away...
Overall summary:
Final result: ...
March 20, 2013 at 11:55 am
Coolroof (3/18/2013)
how to set the column level encyption in sql server 2008 in production enviroment without drop existing column and what are method available for encrypt the...
March 19, 2013 at 1:51 am
Viewing 15 posts - 166 through 180 (of 279 total)