n_padma (11/5/2008)

---

I have created Transaction-updatable replication between two databases in sqlserver 2005. At the subscriber end if i make any changes i get the following error while saving changes...

Collateral (1/16/2009)

---

Hello Noel,

yes your were right. It was the 'min_distretention' Parameter. It seems, this parameter has an MS-Default of 0. So after I restarted the agents, the data was already...

GSquared (1/16/2009)

---

noeld (1/16/2009)

---

There are *many* things Oracle can do that SQL Server can't. So much so, that Oracle is normally being refused because of its too many knobs....

Now that being...

Bill Richards (1/16/2009)

---

I have a different perspective than many of the blogs I have read. It’s the employer’s money and the employer can do with it whatever he wants....

There are *many* things Oracle can do that SQL Server can't. So much so, that Oracle is normally being refused because of its too many knobs....

Now that being said for...

All it takes to understand why hide salary is to put yourself as the Founder of a firm.

How much would you pay yourself? how much would you pay those...

If you don't have a log analyzer tool AND your db is in full recovery mode you are out of luck 🙁

Don't get it. That STILL needs to get the db OFFLINE!

For some reason I think this is...

This is a bug. You can find some details and possible workarounds in CONNECT

ISNULL has some problems with data conversion (TRUNCATION) if used with variables, watch out for that!

xp_cmdshell uses "SQL Server Account" to run under if there is no proxy associated with it.

You need to run that script under a domain account with the right permissions.

You...

I/O, I/O,...I/O .... Did I mentioned I/O ?

As long as you can handle I/O rate you should be fine.

I have used it for development/test/QA in the past and there have...

FYI: I have successfully Bulk imported 1.3 billion rows files without problems before.

ORDER BY and TABLOCK hints and No type conversions, were the dominant factors in the matter.

It is all about how much time you have available for the operation.

I am with Jeff DO NOT split the file. Just make sure that you have enough space...