You will need to create the excel object in an activex script. Then refer to the excel model to find out how to output text to headers and footers.To get an idea of the code required, record a macro in excel where you put text into a header and then look at the code it […]
2005-05-04
WOW... and I thaught I was starting to know something about t-sql. Where did you learn to do that?? (I know it's just a little trick but still it's not that obvious to do).
2005-04-20
We found out that when we run @@servername that it returned null so I sp_addserver 'ourservername' and restarted SQL. I now relize I should have used the local option with sp_addserver but now I can't connect to my server via QA at all. I have tried local,'servername',IP address and it doesn't work. The server is […]
2005-03-25
I've run into something similar on a regular basis with my servers. Mine occurs on the full .bak as well as the .trn. I'm assuming SQL2K on Win2K(3). If you have the the "Run integrity checks before backups" checked on in the maint plans, and the integrity checks fails -- usually because someone is in […]
2005-03-11
Look in Books OnLine for sp_add_jobstep where the specifaction for the @command can include one or more of the case-sensitive tokens which are replaced at run time. These token are not availalbe under query analyzer but only is a job that has been invoked by an alert !Be sure to wrap the tokens with double quotes […]
2005-03-03
As Jeff just told you, at the really first step you have to check the indexes.Use the Profiler to check which are the statements using the most of the ressources (either Duration or CPU or disk).Afterwords you can execute those queries in QA where you can check the access plan. So you can see, whether […]
2005-02-22
besides constraints can be disabled indexes can't (on 2005 you are able to disable indexes, that's cool )HTH
2005-02-16
My guess would be that there would only be extra overhead when the RaiseError was invoked (Maybe not even then).You could test it by running a script without any RaiseError statements then adding the RaiseError statements and comparing the results. If the timings are the same with no errors conditions, then you should be okay. Hope […]
2005-02-14
<% var to = Server.CreateObject("ADODB.Recordset"); to.ActiveConnection = MM_s4r_STRING; to.Source = "SELECT newdate, news FROM dbo.news"; to.CursorType = 0; to.CursorLocation = 2; to.LockType = 1; to.Open(); var to_numRows = 0; %><% Response.Write "&news=" & Server.URLEncode(to.Fields.Item("news").Value) Response.Write Server.URLEncode(to.Fields.Item("newdate").Value) %><% to.Close(); %>
2005-02-14
2004-09-08
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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