'SQLDUMPER library failed error

SQLDUMPER library failed to initialize error:

Sometimes, we used to get this kind of error while starting SQL Server (or) while start or shut down of windows operating system. This is due to improper installation of SQL Server.

Solution:

Goto control panel=>administrative tools->services. Stop unwanted sql server related services. Specifically check for SQL Server VSS writer services. Right click and stop it.

Probably, you wont get any errors.

Thanks and Regards,

Venkatesan Prabu .J

HOW MANY COLUMNS in a SQL Server table

Query for the users with access rights on system tables, compatible for sql server 2000/2005 and other versions.............

select count(*) from sysobjects o join syscolumns c on o.id = c.id and o.name = 'tableName'

Query on 2005 and above for users....


select count(*) from information_schema.columns where table_catalog ='master' and table_name='venkat'

Thanks and Regards,
Venkatesan Prabu .J

New user creation in sql server

Today, I have tried to create a new user for my sql server. But, I got a peculiar problem




------------------------------ADDITIONAL INFORMATION:
Login failed for user 'venkat'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476
------------------------------BUTTONS:
OK------------------------------

Solution:

The problem is due to sql server installation. SQL Server is installed with mode as windows authentication. We need to change it to mixed mode authentication. The problem is resolved. Goto Server, right click ->properties->Security.

Thanks and Regards,

Venkatesan Prabu .J