Viewing 15 posts - 7,126 through 7,140 (of 9,643 total)
Sql Server does not come with any open source software.
RedGate tools are not open source either.
October 23, 2008 at 1:23 pm
You have a couple of options but an easy one is to connect to the Integration Server that currently host's the packages and, right-click on the package(s) and select Export,...
October 23, 2008 at 1:22 pm
You can embed the ASCII character codes for Tab (Char(9)) and Carraige Return and Line Feed (Char(10) and Char(13), I can never remember which is which). Or you can...
October 23, 2008 at 1:17 pm
To add to Lynn's suggestion, batch your updates and do a TX log backup after each batch, this will free up space in the TX log to be re-used and...
October 23, 2008 at 10:13 am
Yes you do need to remap to the column named you provided in your data conversion transform.
October 23, 2008 at 10:11 am
I found this thread, http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/025aefef-e7ba-4fd4-b4a8-00925d9bee34/ and it looks like you need to change your data format to "MM/dd/yyyy".
October 23, 2008 at 10:10 am
The BEGIN and END are not necessary and they are not causing the locks. Exclusive locks are necessary in order to do the updates, you don't want someone else to...
October 23, 2008 at 10:06 am
Yes, the ShowPlan_XML does display graphically in Profiler.
Barry,
Have you used the ability to import and sync with Performance monitor logs yet?
October 23, 2008 at 9:57 am
Are you converting ALL your columns?
October 23, 2008 at 9:55 am
I'm not sure why you posted this on a SQL Server forum when it is asp/VBScript error.
It looks like you are trying to what you really want is something like...
October 23, 2008 at 9:53 am
What is the reason for this requirement? It sounds to me like you really are producing multiple reports. Here are some questions that may help define the best way...
October 23, 2008 at 9:45 am
I just read on Grant Fritchey's blog that SP3 is close to coming out, http://scarydba.wordpress.com/2008/10/22/sql-server-2005-sp3-2/
I am waiting for it as I am not experiencing any issues with my SQL...
October 23, 2008 at 5:43 am
What is the time frame for which you would like to see concurrent users? Second, Minute, Hour?
October 22, 2008 at 10:18 am
Wayne,
I assume you are asking for a subscribe to discussion link at the top of articles/editorials/qods. I agree that would be nice option also, but you can go into...
October 22, 2008 at 9:59 am
Viewing 15 posts - 7,126 through 7,140 (of 9,643 total)