"Look out for definitions that take up multiple rows in syscomments - the "text" column is 4000 characters only." Thanks - I ran into this, and just...
Err.. I haven't read your post very carefully, but you do know that when you define a view, the columns can be SQL expressions of any complexity, not...
Can you not use some dynamic SQL?i.e. Have some dynamic SQL that creates an appropriate table, then executes the stored procedure, storing the...
For SQL Functions and Procedures, I can retrieve definitions using select ROUTINE_DEFINITION from INFORMATION_SCHEMA.ROUTINES Is there any way to...
My suggestion is to have a table that accumulates new records (an input buffer), then periodically take records from that table into the permanent...
Well I'm all at sea here, but is it that only CREATE requires sorting, online REBUILD does not do any sorting, because the original, already sorted,...
Ah, the word document located http://technet.microsoft.com/en-gb/library/cc966402.aspx states "When both SORT_IN_TEMPDB and ONLINE are set to ON, the...
joetig Apologies, you are right, I didn't read carefully enough. My guess is that online=on uses different code, and Microsoft didn't see the need to...
Not familiar with this, but it looks like SORT_IN_TEMPDB cannot be used when ONLINE=ON. ONLINE=ON is the more important option ( since it has a major...
You need to use "union all", for example select customer, total, date from Invoice union all select customer, -total, date from CreditNote If you...
Thanks Adriaan Yes, looks like I will have to make a test version of the procedure, and use an editor to globally substitute '#' with 'temp_'. I...
ZimWell it's a little unusual - usually a web page is a script that is invoked when the HTTP request comes in, and then terminates soon afterwards...
I have a stored procedure that uses explicit temporary tables ( e.g. #treatments ) In Query Analyser (SQL Server 2000), when I click to display the...
Another way would be to set up a secure TCP/IP "tunnel". http://www.securityfocus.com/infocus/1677 describes how to do this for VNC, but I think it...
Later.... after more thought. What you need is a version of the TCP/IP Client/Server library pair that supports client certificates. I didn't find...
Nobody has answered, so I'll state that I don't see how this can be done directly. Certificate based authentication is available at the web server...
I checked my web page and is so simple that is impossible that it can be causing any harm. It only creates a connection once , then it launches a...
"ASP0113' script timed out" Tentative suggestion : are the scripts having problems connecting to the database? Maybe too many connections, with...
The first table is really the problem, it would be better if it had the start and stop in a single record. As things are you need something like...
Ok, sounds like it is mainly a problem with too much parallelism. Have a read herehttp://www.mauvais.com/publish/ZD-Parallel.htmPossibly you should...
Separate names with a comma.
