Viewing 15 posts - 211 through 225 (of 297 total)
Have you tried setting the AllowInProcess property for the provider you are using
EXEC master.dbo.sp_MSset_oledb_prop N'xxxPROVIDERxxx', N'AllowInProcess', 1
or
Server Objects | Linked Servers | Providers | Right-click on a provider, and...
July 17, 2009 at 2:22 am
Is DB Mail enabled?
DatabaseMail on the SQL Server Agent -> properties -> Alert System (check the checkbox), and then restart SQL Server Agent.
Can you telnet to the SMTP server...
July 17, 2009 at 2:05 am
Things should be ok depending on how you are doing this
- Backup/Restore?
- Detach on SRV1 and attach on SRV2.
Once restore you make need to fix the logins using sp_change_users_login.
User exists...
July 17, 2009 at 2:02 am
Grant, sorry to to inform you but I started a new job about 4 months ago and 12 or so tables had over 15 indexes on (one had 33). This...
July 16, 2009 at 9:57 am
Have you checks Dave's blog out...
July 16, 2009 at 9:49 am
The best way maybe to spilt the 2 updates out into 2 "Steps",
Also remove the "NOCOUNT" from the beginning of the script.
This should display the number of rows...
July 14, 2009 at 1:44 pm
The best way maybe to spilt the 2 updates out into 2 "Steps",
Also remove the "NOCOUNT" from the beginning of the script.
This should display the number of rows...
July 14, 2009 at 1:43 pm
- Create Job
- Create Step 1 (your update statement) and in the Advanced section use an output file.
- Create step 2 (code below - replace with your variables).
EXEC...
July 14, 2009 at 10:29 am
If your "Step" is T-SQL and when you execute it returns your total row count, then you should be able to output that using the "Advanced" section for the specific...
July 14, 2009 at 10:02 am
Hi
Have you looked at...
July 13, 2009 at 2:07 am
More info is required.
- Are you rebuilding indexes
- Are you updating Stats
- What version of SQL?
- Server Spec
July 13, 2009 at 2:05 am
http://blogs.msdn.com/sqlserverstorageengine/archive/2009/01/04/what-is-allocation-bottleneck.aspx
If you read this article it explains the process of "Store Allocation".
As the article says TempDB is used allocation, therefore improving the performance of TempDB could reduce...
July 10, 2009 at 8:34 am
Just found an suggestion for this counter (now include it in my alerts)
> 640
http://www.grumpyolddba.co.uk/monitoring/Performance%20Counter%20Guidance%20-%20SQL%20Server.htm
July 10, 2009 at 8:07 am
Viewing 15 posts - 211 through 225 (of 297 total)