Forum Replies Created
Viewing 15 posts - 241 through 255 (of 294 total)
-
RE: The Best Kept Secret About SQL Query Analyzer
The only way I can think of is with my earlier posted VB Script. You have to enter the Query, put the column headers in the script, and edit the...
-
RE: Finding the Next Business Day Recursively
Paul Cresham posted an elegant solution for this including working out holidays on the fly, albeit for the UK. It did contain a nifty Easter algorithm, as well as tackling...
-
RE: The Best Kept Secret About SQL Query Analyzer
Try this vbs script
Dim connectionString 'The connection string goes here connectionString = "Provider = SQLOLEDB;Data Source=(local);" & _ ... -
RE: Importing The Latest File In A Folder Via DTS
Replace the code in the ActiveX Script with this:
'********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Dim filePreFix, -
RE: SQL 2000 active/active cluster
Make sure you cluster the DTC Service BEFORE you install SQL. http://support.microsoft.com/?kbid=301600
Also, be aware that if you use distributed Transactions, you need to adjust the security on DTC to...
-
RE: Starting Query Analyzer
This is what my start menu looks like
Windows Key followed by 1 Opens QA, Windows Followed by 2 EM. I also have short cuts...
-
RE: Troubleshooting MSDTC in SQL Servers between W2003 and W2000
Yelena
I can't comment on different versions of MS SQL as my Distributed transactions are:
- Between the SQL Server & Oracle 9i
- Between different MS SQL databases on the same server
Dave J
-
RE: Troubleshooting MSDTC in SQL Servers between W2003 and W2000
This is how got DTC to go with Windows 2000 clients to a Windows 2003 SP1 Cluster running SQL 2000 SP3a
On the W2003 SQL server, Open Contol Panel/Administrative Tools/Component Services
Navigate...
-
RE: How to synchronize between sql client and sqlserver
what command is EM using? Capture the command in Profiler.
Then put that in your script if it errors?
-
RE: How to synchronize between sql client and sqlserver
Is it still firing up? Try adding a small waitfor delay '00:00:30' after
-
RE: How to synchronize between sql client and sqlserver
The only way I know to do this is to create a temporay table (#temp) at the start of the batch, and after every DML/DDL statment check the @@Error system...
-
RE: Error with linked Server
I tried, but now I get
Server: Msg 7416, Level 16, State 1, Line 37
Access to the remote server is denied because no login-mapping exists.
-
RE: SP4
Is anybody else slightly perturbed by the output of
Select @@Version
------------------------------------------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright...
-
RE: SP4
So have I
Applied to my laptop running XP sp1, on top of an 818 build of SQL 2000 (Developer)
Jacko
-
RE: Importing The Latest File In A Folder Via DTS
I agree, it is a complex solution, but each to their own
I restore a db each day using a similar trick, again using...
Viewing 15 posts - 241 through 255 (of 294 total)