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...
Tommy
Follow @sqlscribeNovember 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...
Tommy
Follow @sqlscribeNovember 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
Tommy
Follow @sqlscribeNovember 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...
Tommy
Follow @sqlscribeNovember 27, 2007 at 1:36 pm
You can use SSL assuming your smtp relay supports it.
Tommy
Follow @sqlscribeNovember 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 -
http://www.developerdotstar.com/community/node/327
Tommy
Follow @sqlscribeNovember 21, 2007 at 8:57 am
SQLIS is a great resource on the WWW - http://www.sqlis.com
Tommy
Follow @sqlscribeNovember 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?
Tommy
Follow @sqlscribeNovember 19, 2007 at 7:29 am
November 16, 2007 at 2:25 pm
Refer to KB 246133 (http://support.microsoft.com/kb/246133/)
Tommy
Follow @sqlscribeNovember 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
Tommy
Follow @sqlscribeNovember 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).
Tommy
Follow @sqlscribeNovember 12, 2007 at 2:04 pm
NP 😀
Tommy
Follow @sqlscribeNovember 8, 2007 at 2:30 pm
Viewing 15 posts - 391 through 405 (of 566 total)