Viewing 15 posts - 3,331 through 3,345 (of 6,679 total)
GSquared (3/22/2011)
Calling third-party DLLs (address list validation and presorting)Disk data (space available, used, etc.) on network resources
Disk operations (file archiving and compression, file encryption)
Running totals
SFTP upload/download (SSIS won't do SFTP)
SSIS...
March 22, 2011 at 7:43 pm
To add to what Grant and Gail have stated - if you perform your integrity checks on a separate instance and it fails, you cannot assume that there is a...
March 22, 2011 at 11:45 am
Lindsay, do you really need a temp table on the linked server? Or, do you need a temp table locally so you can compare to your local table?
Instead of...
March 22, 2011 at 11:37 am
The perform volume maintenance right is needed to enable instant initialization - probably not your issue though.
You are already looking at the things I would focus on.
March 22, 2011 at 11:34 am
Are you running Standard or Enterprise Edition?
Do you have lock pages in memory right set for the service account?
Do you have perform volume maintenance right set for the service account?
If...
March 21, 2011 at 7:25 pm
This is not about the server having access, but the login matching the domain account. If the domain account is all uppercase, and the login is not - you...
March 21, 2011 at 7:12 pm
For some reason, that instance of SQL Server (or that system) is having problems communicating with the domian controller.
When an agent job starts up and is owned by a domain...
March 21, 2011 at 2:30 pm
I would probably go with a third option:
Create a separate instance of SQL Server for each one. This would keep each database in it's own instance, with the same...
March 21, 2011 at 2:22 pm
A global temp table will only exist as long as there is a process accessing it. My bet is that once your process completes, there is no active connection...
March 20, 2011 at 10:02 am
Instead of writing your own search utility, go to Redgates site and download their free SQL Search utility. This will search all objects in the database - or system,...
March 20, 2011 at 10:00 am
The issue with updating statistics after a rebuild is that it will update statistics that were just updated by the rebuild index task.
Instead of using the update statistics task in...
March 18, 2011 at 3:25 pm
You need to check the windows event logs to see why the server crashed - or if the server was shut down and restarted.
If there is nothing in the SQL...
March 16, 2011 at 2:38 pm
Would you mind posting what the problem was and how you solved it? It could help someone else later on.
March 14, 2011 at 7:52 pm
Because a table name cannot start with a number, unless you quote it. You can quote it using either brackets or double-quotes. For example:
ALTER TABLE [3NF_Medarbejder] ALTER COLUMN...
March 13, 2011 at 7:50 pm
Viewing 15 posts - 3,331 through 3,345 (of 6,679 total)