Before SQL Servers stops completely it will log a message both in to SQL Server Error log and OS Eventlogs, Works the same way when you start the sql server. Check you Errorlog you will see " SQL Server is starting at priority class 'XYZ'( # CPUs detected)" and "SQL Server is terminating due to […]
2003-07-03
1 reads
here's a script i've used for quite a while... ------------------------ USE master go ALTER DATABASE yourdatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE yourdatabase FROM DISK = 'c:\path\filename' with replace ALTER DATABASE yourdatabase SET MULTI_USER go ------------------------ I generally run it from a batch file with something like: osql -E -d master -i db-restore.sql -o […]
2003-07-03
1 reads
Hi, quote: Hi, it seems that the client does not have the rights to read from the snapshot-folder. During the setup of the publisher you have to choose the initial snapshotfolder (Default setting is something like this \\ServerName\d$\Program Files\MSSQL\DATA\ReplData). SQL-Server always uses this system link to d$ to which a 'normal' user has no rights […]
2003-07-03
1 reads
sample code in VB i found somewhere 'write to sql Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim mstream As ADODB.Stream Set cn = New ADODB.Connection cn.Open "Provider=SQLOLEDB;data Source=<name of your SQL Server>; Initial Catalog=pubs;User Id=<Your Userid>;Password=<Your Password>" Set rs = New ADODB.Recordset rs.Open "Select * from pub_info", cn, adOpenKeyset, adLockOptimistic Set mstream = […]
2003-07-03
1 reads
Hey guys - thanks for the advice and my apologies on getting impatient 🙂 Turns out that the components being used to alter the table had a hardcoded timeout time. This has now been fixed and the timeout extended. See ya'll later!
2003-07-03
1 reads
Hi, I'll just relate an incident from just a couple of days ago. I had a 10 second proc that ran < 1 second in QA. Took me a while to do what you have been advised to do. Instead of putting the sql into QA I put: exec stp_MyProc And the execution plan was […]
2003-07-02
Use Query Analyzer to look at the execution plan for the statement when you pass in a variable and when you provide the value direct. If you have multiple indexes on a table, I've found that the optimizer can choose the wrong one when querying using a variable. If that's the case you can use […]
2003-07-02
2 reads
2003-07-02
1 reads
Thanks, thats very helpful. What kind of problems are likely to occur using the linked table system - what are the alternatives? For the second part to my question - would an access user be able to link to the DTS task an activate it?
2003-07-02
If your importing you are checking DTSSource ;)] Why not use ActiveX for the column in question, ie Function Main() If DTSSource("x") = True Then DTSDestination("x") = null eElseIf DTSSource("x") = False Then DTSDestination("x") = null Else DTSDestination("x") = DTSSource("x") End If Main = DTSTransformStat_OK End Function
2003-07-02
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers