Hmm it's strange, please correct me, if you know, where is the mistake ?

declare @first datetime

declare @Last datetime

declare @dbname sysname

set @dbname = 'komes'

exec ('SELECT @Last =...

I am using master db, cause I have cca 30 different databases, where I would like to set up sql job for deleting huge table lcs.auditlog_hlavicka after database restore. These...

Markus, your scipt did not work ! The result was the same. This script do not solve the problem with null password.

I used original script from page:

http://support.microsoft.com/kb/246133/EN-US/

and I...

Thanks Markus, I will try your script tomorrow.

I found out that this error causes only user's accounts without passwords (blank passwords). I think that this issue is a blame of...

I don't know what I am actually doing wrong, I tryed to transfer logins using stored procedure sp_help_revlogin >

http://support.microsoft.com/kb/246133/EN-US/

but when I run generated skript for creating users account...

thanx,

hmmm actually I now what cmpt. level 80 and 90 does mean, but what I'd like to know is, what is the basical difference between those levels. I would like...

uf, thanks for your advice !

The command "dbcc updateusage" helped solve this problem !

Actually the database was shrinked as well as indexes, but only stupid statistics was not updated...

hmm, actually I need to shrink db after large deletion of junk data. Before any changes was made, db was at 25 GB with transaction log, now has 4,8 GB....

Thanx,

I read something on microsoft page about system requirements, and I found something.

SQL 2005 standart x86 is limited up to 4 GB Ram, the x64 version has no limitation.

For a...

I did it !

It is very simple

SQL 2005 installation has removed key from

HKEY_CLASSES_ROOT\CLSID\00100100-1816-11D0-8EF5-00AA0062C58F

I placed them back, and it works ! (Enterprise Manager)

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\CLSID\{00100100-1816-11d0-8EF5-00AA0062C58F}]

@="Microsoft SQL Enterprise Manager SnapIn"

[HKEY_CLASSES_ROOT\CLSID\{00100100-1816-11d0-8EF5-00AA0062C58F}\InProcServer32]

@="C:\\Program...

Shit !

I have to reinstall sql server 2000, because the new one (2005) does not work with our company program (Noris) - it stops with error after running. The only...

thanx to all guys ! And especially to Gabor Nyul.

I am begginer in sql administering and in SQL using. Each hint is very important for me. thanx