Viewing 15 posts - 1 through 15 (of 24 total)
Looks like SQL 2000 used to have an xp_readmail command but depreciated in SQL 2005. I've found a few .NET scripts and SSIS. However, the simplest solution looks like Pragmatic...
July 10, 2018 at 11:36 am
This may be due to Verbose logging being turned on for SSISDB. Right click SSISDB under Integration Services Catalog and select properties. Change Verbose to Basic.
March 6, 2015 at 5:29 pm
One big caveat is the size of the datasets being used by CTEs. Be very cautions for two reasons: recursive CTE can blow up your temp db when large datasets...
July 17, 2012 at 9:36 am
The most important concept here is that a responsible DBA should be monitoring the health and activity of the data servers proactively. Over the past 10 years I have seen...
January 28, 2010 at 10:46 am
SELECTTOP 100 (select count(*) from X) AS Total_Counts,
*
FROMX
November 20, 2009 at 4:40 pm
At the last three jobs I have had as a DBA I have set up “Dashboards”. The first was an ASP page that connected to each data server and executed...
July 21, 2009 at 3:36 pm
I received and tested a hotfix for this problem today. Per Microsoft: “this fix is available… it will be documented in our knowledge base using article number 935843 and...
April 17, 2007 at 6:48 am
I have an open case with MS and am waiting for a resolution. I will post additional information as is becomes available.
April 11, 2007 at 11:22 am
A poorly worded question which implies *mdb is a supported file format.
October 26, 2006 at 6:22 am
That's where I am having the issue. I have tried to copy the ActiveX script into the script component but it looks like the language/format is different.
September 26, 2006 at 8:20 am
How is the Sys Admin changing the name? I have had similar issues and found that if I opened the current package and saved it under a new name the...
September 21, 2006 at 1:38 pm
Have you tried creating a Linked Server to AD?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource'
GO
EXEC sp_addlinkedsrvlogin 'ADSI', false, 'DOMAIN\Administrator', 'CN=Administrator,DC=DISTINGUISHED_NAME,DC=com', 'PASSWORD'
GO
September 8, 2006 at 11:54 am
You can also use an Active X Script task in DTS to delete the file:
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
Dim fso, filespec
Set fso = CreateObject("Scripting.FileSystemObject")
filespec = \\Server\path\file.xls
If (fso.FileExists(filespec)) Then
...
September 8, 2006 at 11:50 am
Have you tried SQLPing? http://www.sqlsecurity.com/faq.asp
or isql -L or osql -L ?
September 6, 2006 at 6:29 am
Why don't you make the BatchID column and INT IDENTITY(1,1), that way any insert would autmatically increment the BatchID by 1?
August 25, 2006 at 12:30 pm
Viewing 15 posts - 1 through 15 (of 24 total)