Viewing 15 posts - 5,986 through 6,000 (of 7,168 total)
Sumanta Roy (6/20/2011)
Hi,Is there any way we can measure how much is the database growth in last one hour if the database size is not captured before one hour?
I am...
June 20, 2011 at 11:03 am
You may want to have a look at master.sys.xp_enumerrorlogs. It's undocumented (means unsupported by Microsoft so don't call them if you have an issue, or me for that matter ;-))...
June 20, 2011 at 10:49 am
I don't know about *bright* but a try/catch might do some good. If an exception is thrown control will change to the catch block, the message will be output to...
June 20, 2011 at 10:31 am
Here is a bcp.exe example:
bcp "SELECT * FROM master.sys.tables FOR XML AUTO, TYPE" queryout C:\example.xml -S SERVER\INSTANCE -T -c
bcp can be used against any version of SQL Server.
June 20, 2011 at 10:20 am
That's why I said "It won't affect you" ... you lucked out that it fit your use-case 🙂
June 20, 2011 at 10:05 am
I latched onto this thread as a watcher to try and learn something from it so, sorry, I cannot offer any technical assistance.
I could see where replicating from Oracle to...
June 20, 2011 at 9:40 am
err...the title of the thread is:
"copy files created in a folder two Months ago to another folder"
June 20, 2011 at 9:23 am
Jeff Moden (6/19/2011)
opc.three (6/18/2011)
June 20, 2011 at 9:19 am
Thank you for attempting to provide what I asked for, however that is quite what I had in mind. Did you read the article? Specifically first section titled "The Wrong...
June 20, 2011 at 8:06 am
Hi Brandie, It would be ideal if SSIS contained component(s) to do this kind of work without having to use a Script Task or involving PowerShell, I would actually prefer...
June 20, 2011 at 7:56 am
Sorry, almost missed the point...
Using EXCEPT you'll be incurring a lot of the same comparison overhead by comparing every column in both sets. Have you run both methods side by...
June 20, 2011 at 6:46 am
The MERGE statement evaluates the predicates in ON clause and applies all assignments in the WHEN MATCHED...THEN clause. What are you trying to prevent by adding the additional checks...a trigger...
June 20, 2011 at 6:42 am
Tao Klerks (6/19/2011)
June 20, 2011 at 6:31 am
robinrai3 (6/20/2011)
... then I assume the ssis package waits there till until it finisheshow do you notify to the package if it has failed or been successful
Phil provided the...
June 20, 2011 at 6:17 am
What have you tried so far? I am willing to help you if you can provide the following:
1) DDL and DML to build some sample tables.
2) Expected results.
3) The queries...
June 20, 2011 at 6:05 am
Viewing 15 posts - 5,986 through 6,000 (of 7,168 total)