Did you create Logins in SQL server for the non-admin users?

Sounds like the admin users can access SQL Server through the Built-IN\Adminstrators group while non-admin users have no login/user account...

The reason you don't get the results you're expecting is that Full-text search uses a list of noise words. Noise words are words which normally are not very usefull during...

I'm afraid you won't find what you're looking for by looking at SPID's.

Basically whenever a new connections is made to SQL Server it will get the lowest free SPID...

You need to join sys.objects with sys.schemas.

Something like this

SELECT s.name + '.' + o.name FROM sys.objects o

JOIN sys.schemas s ON o.schema_id = s.schema_id

About the licensing issue I'm also not really a 100% sure, but I think that it's ok to manage your Express editions from SSMS which is covered by any other...

heftyp (8/1/2008)

---

Make sure you configure SQL Server to make use of the extra RAM:

AWE Support

I've been working on documenting a standard install myself. A couple other things I'm looking into...

raj (7/31/2008)

---

i think this would help u to retrieve the last record

select * from tablename where Id in ( select top 1 Id ...

The only thing I can think of is using a logreader tool to see in the transaction log (or backups) when a certain record has been inserted/updated.

But if this...

Prakash,

there's no way to find the last record with a query in your design. That's why I always advise to add a createdate and changedate column to all tables.

Is your database in Full recovery mode? If yes, do you take transaction log backups?

If not your ldf will keep all the transactions and will grow unutil the disk...

What exactly would you like to see? You can open (small) mdf files in notepad and see at lot of gibberish, but I assume that's not what you want.

Concerning the...

If you add the same PK value on the publisher and subscriber before synchronisation, it will result in a conflict. What happens next depends on the conflict handler you've chosen....

Using an increment of 2 won't help you, because you will still get conflicting id's. You could use different seed values lie 1 on serverA and 2 on ServerB and...

It should be

DataSource: MS SQL SERVER ( ole db)

Server Name: Servername\ServerInstanceName

You need to use a backslash between server and instancename

Try one of these:

http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl

or

http://www.sqlinform.com/