Hi, I want to insert sql server 2000 data into dbf file insert into openrowset ( 'Microsoft.Jet.OLEDB.4.0', 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;', 'Select * from [item.DBF]') select * from itemfact ...

need a mdx query to retrive result set with country,state,city,postal code with given employee name Thanks in advance...

Also,verify you are having sql server enterprise edition which is the only edition you can have snapshot enable.

...

<p>Also,verify you are having sql server enterprise edition which is the only edition you can have snapshot enable.</p>...

<p>http://www.dbforums.com/microsoft-sql-server/1623654-how-get-client-ip-address-t-sql.html</p>...

http://www.dbforums.com/microsoft-sql-server/1623654-how-get-client-ip-address-t-sql.html

...

While mirroring mirroed database is nor accessible. but using snaphots you can access it.

But database snapshots are available only with Enterprise Edition of SQL Server

...

<p>While mirroring mirroed database is nor accessible. but using snaphots you can access it.</p> <p>But database snapshots are available only with Enterprise Edition of SQL Server</p>...

<p>While mirroring mirroed database is nor accessible. but using snaphots you can access it.</p> <p>But database snapshots are available only with Enterprise Edition of SQL Server</p>...

<p>A varbinary(max) column that has the FILESTREAM attribute enabled at the Publisher can be replicated to a Subscriber with or without the FILESTREAM attribute. (Source MSDN)</p> <p><a href="http://msdn.microsoft.com/en-us/library/bb895334.aspx">http://m...