Viewing 15 posts - 391 through 405 (of 566 total)
Regarding the MSSQL virtual server, just ensure the backup volume is configured in MSCS so that all nodes of the cluster can access the volume; how-to dependency - http://msdn2.microsoft.com/en-us/library/ms177447.aspx
Regarding best...
November 29, 2007 at 8:52 am
I'll make it easy for you 🙂
-- Identify Duplicate Rows
select SomeColumn,SomeKey
from MyTable
group by SomeColumn,SomeKey
having count(*) > 1;
-- Nuke Duplicate Rows
alter table MyTable
add RowID int identity(1,1)
delete from MyTable
where...
November 29, 2007 at 8:46 am
You can view the value of the variable in the watch window. Covered in detail w/ screenshots here:
http://blogs.conchango.com/jamiethomson/archive/2005/12/05/2462.aspx
November 28, 2007 at 6:55 am
If I understand you correctly, you can accomplish by using a script task to populate a boolean variable (in this example validating wether or not a file exists):
Imports System
Imports System.Data
Imports...
November 27, 2007 at 1:36 pm
You can use SSL assuming your smtp relay supports it.
November 27, 2007 at 1:05 pm
You could accompish this using a script task in an onError event handler.
Refer to Daniel Read's post here -
November 21, 2007 at 8:57 am
SQLIS is a great resource on the WWW - http://www.sqlis.com
November 19, 2007 at 8:37 am
November 19, 2007 at 8:35 am
Did you attempt to reinstall OWC 11 (http://www.microsoft.com/downloads/details.aspx?familyid=7287252c-402e-4f72-97a5-e0fd290d4b76&displaylang=en) as the post suggested?
November 19, 2007 at 7:29 am
November 16, 2007 at 2:25 pm
Refer to KB 246133 (http://support.microsoft.com/kb/246133/)
November 13, 2007 at 7:57 am
Declare the cursor LOCAL FORWARD_ONLY STATIC READ_ONLY if thats all User A needs - refer to DELCARE CURSOR options in BOL - http://technet.microsoft.com/en-us/library/ms180169.aspx
November 12, 2007 at 2:12 pm
Are you running Vista? If so have you run the user provisioning tool for SQL Server 2005 (included in the SP2 installation).
November 12, 2007 at 2:04 pm
Viewing 15 posts - 391 through 405 (of 566 total)