Viewing 15 posts - 16 through 30 (of 56 total)
Michael Valentine Jones (4/27/2011)
You can use them on most major airlines for free upgrades to DBA class.Just ask at the ticket counter when you check in.
Nice. How many point need...
May 9, 2011 at 2:38 pm
Try with SQL Profiler or Minotor, or in the Error log u will see [CLIENT : IP]
find the hostname of the IP with ping -a.
May 4, 2011 at 8:20 am
Nice tip, but i don't see anywhere The eventID for the truncate table operation
April 19, 2011 at 11:55 am
Same, the good answer for me is 4. the Explication and code isn't correct
April 8, 2011 at 9:20 am
Try with a case
SELECT CASE WHEN col2 BETWEEN X AND Y THEN col2
...
March 29, 2011 at 7:09 am
Do you try with a : Begin Transaction before your insert ?
March 28, 2011 at 1:19 pm
Data flow need metadata to work. If #temp table doesn't work try with a normal table
March 22, 2011 at 8:22 am
My [sysmail_help_admin_account_sp] are not the same on DEV/PROD server for SQL Server 2005 sp4 do u think I can update this or another script for update this sp ?
On SQL...
March 1, 2011 at 11:04 am
1.Change the owner of database.
2.Look schema owned by the user and change them.
3.Drop user
I think it's work. But if you paste the error message could help more....
February 21, 2011 at 11:24 am
I use SubVersion. For all my SQL Code and SSSIS packages for DWH.
ANd these plugins :
Redgate SQL Source Control(For Table,Stored procedure)
Tortoise(For documentation)
Tortoise&AnkhSbvn(For SSIS,*.sln) Solution
February 17, 2011 at 10:04 am
Nice Article, but just a simple question. Why the date is in the future: Stairway to Server-side Tracing - Step 3: Creating a SQL Trace Using SQL Server Profiler
By Dan...
February 17, 2011 at 9:46 am
Sory I post it in the bad Section.
http://www.sqlservercentral.com/Forums/Topic1065055-10-1.aspx
February 16, 2011 at 8:50 am
Viewing 15 posts - 16 through 30 (of 56 total)