Stop the server and copy the .mdf file. Then try an attach, overwriting the existing database.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

What type of math? Require user input? an example might help.

If it's simple math, like value * .40, then I'd

update table

set colA = ColA *.4

where pk =...

Update:

Nothing between the servers except a switch. They may be on separate VLans, so it's possible it is multiple switches.

However, I can run these queries together in one batch, with...

I'd do one table as

create table(

id identity

, boxname varchar

, boxvalue varchar)

or with two tables, a lookup the the boxname and one for the values, FK to the boxname table.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Used it (for the most part) as is. Modified the code a little, so we're behind in some areas from Snitz. Afraid to do the upgrade since it's pretty stable.

It...

The overhead for checks is small. Plus it's then distributed. I see a constant connection as a failure point, especially since if you do not check the link constantly, it...

I use SourceSafe, but script the entire db, everything, and be sure it is branched when the software code cuts. I'd keep this in a separate project with the date...

It was a problem presented to me and it was in a narrow scope. Thanks for pointing out those bugs, I should have included those limitations in the article so...

In real time or later from a log?

Would be easy to display the data in a web page. Like any other query displayed on a page. Hard to give you...

With a big stick, a loud voice, and a good audit policy

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Intersting. Looks like a bug. Tried this and it fails

select

len(col1)

, replace(col1, ' ', 'x')

, len(replace(col1, ' ', '-'))

, col1

from t1

From BOL, len returns the number of characters, not...

You can look at the MS Baseline Security Tool (http://www.sqlservercentral.com/columnists/sjones/reviewmicrosoftbaselinesecurityanalyzer.asp), but it has bugs.

There isn't a good patch manager for SQL. Hopefully one will get built soon.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Agree with andy. It can cause disk space issues as the more your capture, the more is stored.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

I'd suspect you have an application problem. SQL Server should take up most everything except 128MB or so which is left for the OS. I had about 1GB of databases...

When testing Brian's suggestion, log into the server with the same account that SQL Server runs under.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones