Viewing 15 posts - 646 through 660 (of 1,248 total)
Got a link about how to extract a compressed backup to native backup.
February 26, 2008 at 10:33 am
You should not use sa account to copy a file from one server to another. You should use a domain account.
To look whether or not an account has authority...
February 26, 2008 at 10:24 am
If your databases are huge, you may consider to use attach/detach approach.
February 26, 2008 at 10:19 am
I agree with others' inputs. You may also check AutoGrowth for databases in this filegroup.
February 26, 2008 at 10:17 am
I believe that you would like to translate one language to another in SQL Server Reporting Services.
I do not think current SQL versions have this funciton.
February 26, 2008 at 10:11 am
Cost for indexed table is unnecessarily less than table scan if indexes are not created correctly.
February 26, 2008 at 10:06 am
Personal point of view.
You may have to map login info, then reset the database backup to readonly status.
February 26, 2008 at 10:02 am
If I understand your question clearly, you may try the following code
SELECT name, createdate, updatedate from master..syslogins
February 26, 2008 at 9:59 am
I am not aware of any. I would be interested if anyone would.
February 22, 2008 at 2:06 pm
There are many other approaches to send emails from an SQL Server, such as CDONT. You do not need any mail server to implement your tasks.
February 21, 2008 at 1:06 pm
How about to grant EXEC to your user for executing this stored procedure?
February 20, 2008 at 9:06 pm
Error 1067 is a general error. Check your SQL logs and event logs and see what you find.
This error may indicate an error in registry also.
February 20, 2008 at 9:04 pm
Go to the source server to check whether or not the table exists, including its owner;
Check whether or not the link works.
February 20, 2008 at 8:55 pm
Viewing 15 posts - 646 through 660 (of 1,248 total)