when SQL is deep in the militarized zone, beneath multiple layers and security levels, the application DB access configuration is hidden, you have a complex but good authentication/authorization at application...

If the database is not in Simple Recovery mode, then you must do a transaction log backup before you can shrink the files. You should have regularly scheduled transaction...

You need to set the timeout of your connection object AND your command object, default timeout is 30 seconds

e.g.

DIM cn as NEW adodb.connection

DIM cmd as NEW ADODB.command

cn.connectionstring = cnstr

cn.connectiontimeout =...

Jamie, create a tally table that has a column of integers from 0 to <some large number: say 8000>

Then You can write a query like

SELECT n, SUBSTRING(<rowname>,n, 48) as splitdescription

from...

Since there are needed more than 255 columns for Bo, Bo2 was created and for each Bo line there's also another in Bo2, thus Bo2.Bo2stamp = Bo.Bostamp <<

NO! The whole...

Instead of joining:

From bo(nolock)

Left Join bi(nolock) On bi.bostamp=bo.bostamp

Left Join bi mybi(nolock) On mybi.obistamp=bi.bistamp and bi.qtt<>0

Left Join bo mybo(nolock) On mybo.bostamp=mybi.bostamp

Left Join bo2 (nolock) On bo2.bo2stamp=mybo.bostamp

Where bo.ndos=5 and bo.boano=2010 and bi.qtt<>0...

How many rows will be left in the table when you are done?

If the answer is 0 then TRUNCATE TABLE.

If the answer is small then create a new table with...

Ok, I thought about this a bit more and I don't like the loop. So I came up with the following that requires a Tally Table (A table of...

This code seems to be overly complicated for the task presented. Why are you saving off the Chopped part of the input? If I needed this functionality I...

I think the problem is that, as you move further down the chain of authority, the employee doesn't know what their boss "needs to know". Of course I should...

Steve,

I tend to agree with paul.knibbs. Buy the SQL Server engine on a per-processor/RAM basis then add feature modules to get the product you want. If you want...

Not really. We get access change requests pretty often. People change departments or...

YSLGuru,

ANyone know of a good way to get Meta data (sometimes called a data dictionary) out of a PDF and into something more easy to insert into t-SQL code? The...

Jay,

In your response you are assuming that the bureaucrat's job is to punish you. In truth the bureaucrat (who is, after all, just another office worker like the rest...

It was a PITA, and I can't remember if it went to the state (probably) or the feds, but they seemed to take a dim view of "candidate not qualified"...