Viewing 15 posts - 3,421 through 3,435 (of 3,738 total)
The following link may give you some ideas:
http://www.eggheadcafe.com/community/aspnet/2/10074732/upload-a-word-or-pdf-file.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 7, 2010 at 7:24 pm
I wrote DTS & SSIS Packages to Backup the Production Database, copy it, write a SQL Script to create the Database if it does not exist.
I did this to refresh...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 7, 2010 at 7:02 pm
Powershell is a very powerful tool, however there is a bit of a learning curve to master the capabilities of it.
I did not send you the link listed below. I...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 6, 2010 at 1:12 pm
Basically what you are doing when you change the default POrt is change a registry entry.
WHen you create an alias you are modifying the registry as well.
THis can be performed...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 6, 2010 at 10:02 am
Have you looked at the Powershell Utility?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 8:28 pm
Have you gone into debug mode and set breakpoints?
Have you tried altering the package or query so that it only inserts 1 record?
It would appear that you have a mapping...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 6:40 pm
I suggest that you reproduce the problem.
You can run a variation of the script that you initially ran.
Going through the GUI will not assist you in reproducing the problem.
Then I...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 6:30 pm
You can disable a user account via a Group policy.
Anyone who is a local admin, domain admin or enterprise admin inherits the SQL Server Fixed Server Role.
If you run a...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 5:35 pm
Could you share the T-SQL Script that you used?
Are the logins diabled as well as the user accounts?
How long after you created the accounts did you notice that they were...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 5:18 pm
Yes, you can do this, please refer to the following links:
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/
http://msdn.microsoft.com/en-us/library/ms141724.aspx
I hope this helps...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 5:14 pm
Try the following links. I got a few other hits so let me know if this works for you.
http://dbaspot.com/forums/sqlserver-programming/391006-bcp-out-including-column-question.html
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 4:04 pm
Could it be that the record in the master table has not been committed?
What about batch size?
Try going into debug mode, set break points and after the Insert into the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 3:49 pm
Nicholas Cain (3/5/2010)
--------------------------------------------------------------------------------
It could be any number of things.
You need to take a look at the way memory and cpu are being handled, whether it's the page draw that's causing...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 1:23 pm
No worries.
I was not being critical.
Have a nice day!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 1:20 pm
Please look into perfmon as was suggested to you.
That is a biggie.
You can Goggle of you have one of the DBA Books they all have sections on performance.
You are doing...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 1:10 pm
Viewing 15 posts - 3,421 through 3,435 (of 3,738 total)