I admit it, I speak german as well. But does that mean a erman speaking forum would be a good idea ??? Personally I don't think sobecause you'll loose the...

I agree with the fact that sp_change_user_login is the right way to it but I'm not happy with the AUTO_FIX option. Update_one seems to be the better way.

Change the datatype for @boxsize to deciaml(5,2) instead of real and it works.

I ran it on SQL2K it it did work for me. Although the database seemed to be ok in EM, as soon as you run a SELECT on the table...

I've solved this problem by creating a job which changes the recovery model and makes a full backup every time SQL Agent starts. Just select this option in your schedule.

...

The sqlmaint.exe should be in the folder C:\Program Files\Microsoft SQL Server\MSSQL\Binn

You might be able to recreate it by running the service pack again, since it's part of SP3.

You can still use merge replication, which actually uses a trigger system to keep track of changes. PK are not required for merge.

Myself I'm working partly as Consultants, part trainer and sometimes also as a parttime DBA at various customer sites. First of all I must say that about every company defines...

I would say download a demo version of SQLCompare (www.red-gate.com) or AdeptSQLDiff (www.adeptsql.com). Both do the job nice and easy.

Don't know why this is posted under service packs but the short answer is that you can't build parameterized views. The workaround is to create an inline user-defined function. See...

I agree that running the agent from the command line is the best way for troubleshooting. The disadvantage especially with errors like this one, which happens very irregularly and only...

Yes, I deleted the subscriptions before, but the last time was months ago when we upgraded the Distributor/Publisher and everything was clean. Anyway why should the system create new logins...

Here you have a script which corrupts the IAM of a table. Note that after running the script the table in question is longer accessible while the database status remains...

Not sure if I understand you problem, but a good starting point as ever is Books Online. for more advanced examples try any SQL book or have a look at...

I can see it as part of a PK if you do a lot of time range queries, but definetely not as the only column. The risk of rejected insert...