Viewing 15 posts - 1,966 through 1,980 (of 2,387 total)
I am still look into this problem but meanwhile, I would suggest you to insert result of your linked server query into a temp table and send email by query...
April 22, 2003 at 9:18 am
Can you post more information how do you configure the linked server, especially the security setting.
April 22, 2003 at 8:30 am
Do you have default printer configured in the machine your SQL Server is running? There should not be a space between "c" and ":" in your command.
April 22, 2003 at 8:26 am
This error may come from the query to linked server instead of from x_sendmail. Make sure the query work properly. Meanwhile, if you are runing a job to run this...
April 22, 2003 at 8:16 am
Read this KB article. http://support.microsoft.com/default.aspx?scid=kb;en-us;297864
April 22, 2003 at 8:09 am
What file did you try to change from EM?
First, you have to make sure SQL Server is up and running and then review your SQL Server errorlog and machine system/application...
April 22, 2003 at 8:04 am
You have to create a network share where database and transaction log backups will be and grant SQL Server services account full access to this network share.
April 22, 2003 at 7:58 am
Ther are two type security roles in SQL Server, one is at server level and another is at database level. User with 'DBO' role has all permissions in the database...
April 22, 2003 at 7:50 am
What do you mean "full privilges" here? 'SA' or 'DBO'?
April 21, 2003 at 5:04 pm
Run restore headeronly from disk = 'your master database backup filename' and you will see character set, sort order and unicode setting of your original SQL Server. Rebuild your system...
April 21, 2003 at 9:34 am
It seems you will have large amount data and quite number users going to access SQL Server. Enterprise Edition of SQL Server may be the one you should consider. Look...
April 21, 2003 at 8:57 am
You need only /3GB in your boot.ini file. Enabling AWE in SQL Server doesn't have any effect because your server has only 4GB memory.
I would let SQL Server to dynamically...
April 21, 2003 at 8:53 am
Make sure your SQL Server is up and running. If you can connect with QA, run sp_helpdb to see whether your database shows up.
April 17, 2003 at 1:46 pm
Do you have timeout by running same sp from QA? Have you checked whether there was blocking when it happened?
April 17, 2003 at 9:44 am
Viewing 15 posts - 1,966 through 1,980 (of 2,387 total)