文章

 Connection Strings

We're often asked how to create a connection string to a database.  In fact a variety of...

 How do I Publish my Microsoft SQL server database

In order to publish your database to your hosting package, you need to use the SQL database...

 SQL Enterprise Manager reports 'no items'

Run this script in query analyzer against the master db ===================copy everything below...

 SQL Object Ownership script

DECLARE @objname nvarchar(517),@DynSQL nvarchar(4000) DECLARE obj_cursor CURSOR FORSELECT name...

 SQL db shrink code

--Select Count(name) from sysdatabases declare @db as varchar(100)set @db = 'db to be shrunk...

 Why can't I connect to the SQL server using Enterprise Manager/Management Studio

SQL Enterprise Manager tries, by default, to connect via Named Pipes. As this cannot run across...