I don't have the docs for SQL 6.5, but SQL 7 and above, DDL would be as follows:

ALTER TABLE <Table Name>

ALTER COLUMN <Column Name> <Data Type> <Nullability>

This can be passed...

One of the differences between triggers in SQL Server 7 and 2000 other than the addition of the INSTEAD of trigger is that you can do a limited amount of...

Please do. BTW, what version of SQL Server and what Service Pack?

K. Brian Kelley

bkelley@sqlservercentral.com

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

Are you saying you don't want the permissions and users? If so, I don't see a switch with scptxfr.exe which allows you to choose. In this case, going with...

I like Steve's suggestion best, but from a trigger perspective, you could use IF EXISTS against the table to see if there is already a record with the matching criteria....

Hi Robert,

There is one Knowledge Base article which talks about SQL 7 and slow merge replication. I don't know if the conditions match yours, but here's a look:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281295

K. Brian...

I don't believe this setup actually displays cubes via the browser. I think it's only for setting up an Analysis Server where connections can be made via HTTP such...

If sp_autostats is showing the flags to be on, then it should be. I've been looking at the Microsoft Knowledge Base article, and based on what it says, the...

Profiler is a great tool to collect this sort of information. We are having to do some very heavy auditing on a internally built application and Profiler has been...

As you've indicated, there are a couple of articles that deal with this issue. However, first things first. Here's the link to a script posted by Steve Jones...

Most likely you can. But without knowing exactly what operations you are performing it is hard to say. If you're doing typical SQL queries, then you can set...

I have a physics and mathematics background, so anything to do with sets and groups absolutely fascinates me. Relational databases are all about sets. So naturally I've gravitated...

One thing that was an issue in NT4 was whether or not to configure the server to be optimized for Network Applications (SQL Server) or File Sharing (IIS). The...

That is something I plan on doing. This first article was to solve the question of, "What do I give the developers?!?"

K. Brian Kelley

bkelley@sqlservercentral.com

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

Here's a link from Microsoft about setting up Microsoft Transaction Server. ociw32.dll, according to the document, belongs to Oracle:

http://www.microsoft.com/technet/archive/default.asp?url=/TechNet/archive/transsrv/setup.asp

quote:

---

Oracle Clients on...