Viewing 15 posts - 2,341 through 2,355 (of 3,232 total)
You are currently only backing up the data file once per day? If you have no need to recover to a point-in-time, then consider setting your recovery model to simple. ...
April 9, 2007 at 10:30 am
In addition to the questions that Lynn has asked, can you give us some clarification on what 'fast growth' means to you and why you are concerned. You mentioned having...
April 9, 2007 at 10:10 am
For each History column in the UPDATE and INSERT, you'll need to encapsulate the column name with the CAST function and modify the casted datatype to match the datatype for...
April 6, 2007 at 2:42 pm
In looking at the data types between like columns in your Header and Audit tables, there are many differences where trying to insert Header table values into your Audit table...
April 6, 2007 at 1:16 pm
Here's your set-based UPSERT (you'll need to add in whatever error processing methods you've standardized or you are used to):
UPDATE APH
SET APH.LEA_Code =H.[District Code],
APH.District_Name =H.[District Name],
APH.School_Code...
April 6, 2007 at 12:29 pm
Best,
This looks to be the UPSERT that you've been working on. Is there a reason why you've chosen a cursor to do this when so many have warned against...
April 6, 2007 at 12:23 pm
Keep in mind that this will only give you the very last statement. If you need to see more, you may need to run Profiler and try to capture everything...
April 6, 2007 at 12:10 pm
Use DBCC INPUTBUFFER. If you do not know the SPID responsible for the hang, you may want to either try to narrow the SPID down by reviewing sp_who2 output, or...
April 6, 2007 at 12:09 pm
Simon,
Why would you use a cursor for this??
Best,
Use Steve's solution or the same solution that you got the last time you posed this question here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=354363
April 5, 2007 at 2:34 pm
What about your SMTP server, is it your local SQL Server? Check and see what account the SMTP service is running under.
I had this same problem not long ago,...
April 4, 2007 at 3:37 pm
In what context is xp_smtp_sendmail running? SPROC, DTS, SQLAgent? Is your SQL Server service running under a domain account or local system?
April 4, 2007 at 3:11 pm
The cannot find file error usually either means that the file does not exist, or that access is denied. Check the folder and file permissions on the attachment and make...
April 4, 2007 at 2:55 pm
The INSERT operation will be logged in the transaction log for the database where the data is being INSERTED, in this case LinkedServer2.
April 4, 2007 at 12:14 pm
First of all, calling an executable from within a trigger would be considered not a 'best' practice. I would guess that this executable must then connect itself to the DB? ...
April 4, 2007 at 12:11 pm
Unless the table is in its own filegroup, you can't. You must restore the entire DB to another location and copy/move the data from the table you want to recover. ...
April 4, 2007 at 12:04 pm
Viewing 15 posts - 2,341 through 2,355 (of 3,232 total)