|
|
-
IvanFroilan Question Received 10 Months ago through ASK
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
...
|
-
Bru Medishetty Posted 3 Years ago through Blogs
In this article, we shall look at something that may not be done as
frequently as you would want to. It is Downgrading a SQL Server 2005
from an Enterprise Edition to Standard Edition.
First you need to know why such an exercise is carried out any ...
|
-
Bru Medishetty Posted 3 Years ago through Blogs
In this article, we shall look at something that may not be done as
frequently as you would want to. It is Downgrading a SQL Server 2005
from an Enterprise Edition to Standard Edition.
...
|
-
Bru Medishetty Posted 3 Years ago through Blogs
In
order to know the SQL Server and Edition details you would be possibly
looking at the SQL Server properties and find out the details.
Occasionally it might be needed to check the same as part of a job / or a
script, you need to query the SQ...
|
-
Bru Medishetty Posted 3 Years ago through Blogs
<a href="/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/brumedis...
|
-
Bru Medishetty Commented 3 Years ago through Ask
<p>Yeah Dinesh. That's a good point.</p>...
|
|
|
|
|
-
Bru Medishetty Commented 3 Years ago through Ask
<p>I would suggest one of my blog posts about database snapshot. Please find it here http://learnsqlwithbru.com/2009/10/04/introduction-to-database-snapshots-in-sql-server-2005/</p>
<p>About Database Mirroring Monitor, On the principal server, go the D...
|
-
Bru Medishetty Commented 3 Years ago through Ask
<p>You cannot query the mirrored database. Optionally you can create a database snapshot on that database and query that snapshot to check.</p>
<p>You can also check the status using Database Mirroring Monitor..</p>...
|