Viewing 15 posts - 7,951 through 7,965 (of 11,678 total)
Eric M Russell (2/14/2012)
February 14, 2012 at 12:55 pm
Matt Miller (#4) (2/14/2012)
February 14, 2012 at 12:53 pm
Cadavre (2/14/2012)
Look at his "ID" column. You'll see that he essentially wanted to order that by the "Name", rather than using what was already stored in [Temp#1].
Well, the OP...
February 14, 2012 at 5:21 am
Rachel Byford (2/14/2012)
If you can suggest a better way, however, I'm...
February 14, 2012 at 5:16 am
chandrika.r 91171 (2/14/2012)
I am getting a time out issue when I am running my SSIS package through SQL Job. In the SSIS package I have a simple...
February 14, 2012 at 5:09 am
ID is an identity column, you shouldn't try to force it into a specific order.
Furthermore, it is useless to specify an ORDER BY on an INSERT.
ORDER BY Clause (Transact-SQL)
When used...
February 14, 2012 at 5:01 am
SQLPhil (2/14/2012)
Other suggestions might be installing and configuring a scale-out deployment.
Indeed. For example, the databases on one server, the webservices on another web server and so on...
February 14, 2012 at 4:01 am
This article doesn't tell me much more than MSDN.
I would have liked a more in-depth discussion on some configuration topics, such as the service account (using a built-in one -...
February 14, 2012 at 3:25 am
Hugo Kornelis (2/14/2012)
However, it is not true that ;WITH will cause errors when all statements are semicolon terminated. There is no limit to how many semicolons you use and where...
February 14, 2012 at 3:21 am
And a happy valentine for you as well.
Glad to be part of this community.
February 14, 2012 at 2:38 am
kll 51891 (2/14/2012)
But it were not so
Anywhere I can find specific rules about when to use and...
February 14, 2012 at 2:05 am
ladyblue1075 (2/14/2012)
Wow! It works!Thanks to Koen Verbeeck!!!
No problem, glad to help.
Maybe you could verify the backup first before dropping the database, just to make sure you don't run into...
February 14, 2012 at 1:18 am
danielfountain (2/14/2012)
But surely without running the code there would be no output :0)
Indeed! :w00t:
I'm missing the answer "after waiting for a few hours you eventually decide to go home..."
February 14, 2012 at 1:16 am
You need to create dynamic SQL for this using the EXEC statement (or sp_executeSQL).
Your statement would become:
CREATE PROCEDURE [dbo].[BackUpDatabase]
@BackupFilePath VARCHAR(200) = 'C:\DbBackup\SQ2005\', -- path for backup db
@DatabaseName VARCHAR(100) = 'DBTEST',...
February 14, 2012 at 1:12 am
Great question, thanks Henrico.
I stumbled across this issue a few times too many, so a real easy one for me 🙂
February 14, 2012 at 12:13 am
Viewing 15 posts - 7,951 through 7,965 (of 11,678 total)