DML Triggers

RE: Problem Trapping Alter Database Stmt

The formatting's all off so your post is one long line... however, if you want to check if your code is successful then @@ERROR should return 0. If you have several statements in your proc, it's always good practice to capture this in a local variable.

RE: Question of the Day for 04 Feb 2005

I created the table and used the selection from the question and all that was returned was the message stating that the query was complete. I fully expected that the sentence would be returned but nothing was returned when I ran it. I did a normal select on the table I created and it returned […]

Dynamic Security multiple Dimensions

I'm trying to work with Dimension Security for multiple dimension, but i have som problems that maybe someone can help with.In my exmaple belove i have 2 dimensions. The security should work as, if a user chose UK, he has only allowed to se all things for UK (The X's), but if he chose to […]

RE: Merge Replication Failed - Subscription to publication is invalid

Hi - It sounds as if your snapshot is invalid. The publication has a setting called retention days, check this value & if it reads 14days (for example) it will expire after this period even though the merge agent has been running all the while.A quick way to get a new snapshot done is: Generate […]

DTS database to a different name database

Hi everyone,Hit me, kick me, abuse me whatever, but I gotta ask a silly question.  If you DTS a database from one server to another but you want to call it different name on the second server (you create new database with different name while you are in the DTS process), would this cause any problem?  Would the […]

RE: Migrating SQL Server Jobs

There is a DTS task in SQL2000 to transfer jobs.  The source can be a SQL 7 server and you can select the specific jobs you want to transfer.

RE: Question of the Day for 23 Jan 2004

Granted the defualt fill factor could be changed, however if you ever plan on taking any Microsoft exam you must always assume default configurations unless otherwise stated.When I teach Microsoft courses, I always stress that you have to know those default configs for that very reason.Since the question did not state that we changed any […]

RE: Divide big delete into several small ones

Another point to note is that you can stop this type of query at any point with out losing work already done. So if youe query locks up tables and holds up other users you can easily just stop it. and continue later.

RE: Divide big delete into several small ones

One point to add to this is that you MUST set your rowcount to 0 after the loop! Not doing so will limit all your following queries to the same 1000 records and may really cuase problems. 🙂 Also this can be a way of keeping your log file from growing too large as you […]