Viewing 15 posts - 616 through 630 (of 1,248 total)
Here is a link, which may help you build your link.
March 3, 2008 at 9:16 pm
May the link below help.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2939682&SiteID=1
March 3, 2008 at 3:54 pm
Ask your system administrator (not DBA) to create an account in AD and set expiration time;
You assign this (windows) account in SQL Server with necessary privilege.
March 3, 2008 at 3:38 pm
You may use
DBCC SHRINKDATABASE to implement your task. However, you may not be able to release space occuppied by transactions, which have not been replicated yet.
March 3, 2008 at 3:34 pm
Based on your error message, I would like to say you may need to restore your registry or re-install your SQL Server.
March 3, 2008 at 3:27 pm
In my memory, it is one of disavantages of using DTS packages, that a package runs throught without any error but we cannot get expected results.
Two suggestions:
1. Add a log...
February 29, 2008 at 12:40 pm
All DBCC commands can be run only by system administrators or server administrators by default.
If you would like to include running DBCC commands to a readonly user, you need to...
February 29, 2008 at 12:36 pm
Did you try to change the collation of your database?
February 29, 2008 at 12:21 pm
Could you post your code and error messages?
Normally, you need to use full name while querying data in a remote site.
February 29, 2008 at 12:15 pm
If you have snapshot or transactional replication, you may try,
sp_helparticle 'replicationName'
February 28, 2008 at 3:32 pm
Thank Vivien. I forgot this command.
February 28, 2008 at 10:20 am
So, you mean there is no any command similar to SQL Server,
ALTER PROC ...
?
February 28, 2008 at 10:12 am
Your log file size is only half of 1 MB. It is quite small. SQL Server reserve a minimun size for a log file size, set in the database model.
February 28, 2008 at 9:55 am
I would like to say, it is possible. To permanently solve this issue, you may save all of existing data somewhere, and compare any change while running your monitoring scripts.
February 28, 2008 at 9:43 am
Viewing 15 posts - 616 through 630 (of 1,248 total)