Viewing 15 posts - 3,616 through 3,630 (of 3,738 total)
What error message are you getting in your error handler?
You need to step thru you code and try and capture some additonal information, for correct me if this is wrong...
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/
February 14, 2010 at 6:51 am
Why don't you use a registered server as opposed to a Linked Server?
Also backing up over the network is very slow.
Are the Database Servers in question on the same Network...
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/
February 14, 2010 at 6:45 am
You xcode that you use in your .NET code to generate you paramter collection is flawed and thus generates a syntax error.
Your Stored Procedure if fine.
DECLARE @ART_ID int
SET @ART_ID...
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/
February 14, 2010 at 6:40 am
Why are you using a Linked Server?
Why not use maintenance task or SSIS?
Does it time out when you run your code from Query Analyze ar as a Stored Procedure?
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/
February 13, 2010 at 10:54 pm
It appears that you have the wrong syntax with the paramater in your .NET Code.
If you copy & paste the output frpm Profiler and get an error than it is...
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/
February 13, 2010 at 10:48 pm
Again., my account has been comprimised...
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/
February 13, 2010 at 1:04 pm
My account has been comprimised...
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/
February 13, 2010 at 12:45 pm
This was posted on error om my part.
Thank you for your contributions to this Forum.
Regards...
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/
February 13, 2010 at 7:21 am
Thank you for the clarification...:-)
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/
February 11, 2010 at 7:09 pm
xxx
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/
February 11, 2010 at 6:43 pm
Jeffrey,
Excuse me Sir but Im not sure that I understand your post?
Regards,
WelshS
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/
February 11, 2010 at 4:25 pm
After examining your initial post it is clear that you approach is severely flawed.
I do not like to Criticize other members but I suggest that you Goggle this topic if...
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/
February 11, 2010 at 3:53 pm
I know what backups were performed and when. You can query the system tables.
I used the file System object in addition to the system tables to verify existence of...
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/
February 11, 2010 at 3:33 pm
I routinely used DTS Packaged to refresh the Development,Test & QA Environments.
I also wrote SSIS packaged to do the same on as routine basis. I would take the backup from...
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/
February 11, 2010 at 2:57 pm
Well thank you all for a very positive and constructive dialogue. 🙂
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/
February 11, 2010 at 2:23 pm
Viewing 15 posts - 3,616 through 3,630 (of 3,738 total)