Does SQL 2005 runs on other platforms them MS windows ?

I could not find in the documentation but someone told me that there is a way.

YOu will be able to connect to the SQL Server from any platform where you can find an appropiate driver, but the shipped client tools from MS and the service will only run on WIndows platforms.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Does SQL 2005 runs on other platforms them MS windows ?

I could not find in the documentation but someone told me that there is a way.

YOu will be able to connect to the SQL Server from any platform where you can find an appropiate driver, but the shipped client tools from MS and the service will only run on WIndows platforms.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

does showContig Block ?

does DBCC ShowContig Block ?
I want to run this in prod but cant find any documentation that indicates if
this blocks or not
thanks in advance
GAJHi,
Use WITH FAST option along to avoid blocking.
Note:
A fast scan does not read the leaf or data level pages of the index, so will
not create blocks.
Usage:
USE dbname
GO
DBCC SHOWCONTIG ('table_name') with fast
GO
Thanks
Hari
MCDBA
"Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
news:e#rtZkUDEHA.2052@.TK2MSFTNGP11.phx.gbl...
> does DBCC ShowContig Block ?
> I want to run this in prod but cant find any documentation that indicates
if
> this blocks or not
>
> thanks in advance
>
> GAJ
>|||If you run it on a heap, WITH FAST has no effect and it will still take a
table S lock. WITH FAST allows it to take a table IS lock when run on
clustered and non-clustered indexes.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uld4HaWDEHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Use WITH FAST option along to avoid blocking.
> Note:
> A fast scan does not read the leaf or data level pages of the index, so
will
> not create blocks.
> Usage:
> USE dbname
> GO
> DBCC SHOWCONTIG ('table_name') with fast
> GO
> Thanks
> Hari
> MCDBA
>
> "Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
> news:e#rtZkUDEHA.2052@.TK2MSFTNGP11.phx.gbl...
indicates
> if
>|||crud.
about 80% of our tables are HEAPS (long Story) so running this in prod puts
us on our lips...
Correct ?
Greg J|||Assuming that 'puts us on our lips' is bad, then yes, you don't want to do
it. What are you trying to acheive - there may be another way to do it...
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
news:OdsxqBdDEHA.2308@.tk2msftngp13.phx.gbl...
> crud.
> about 80% of our tables are HEAPS (long Story) so running this in prod
puts
> us on our lips...
>
> Correct ?
>
> Greg J
>

Does LoadFromSqlServer2 method work?

Hi. There's little documentation on the Microsoft.SqlServer.Dts.Runtime.Application "LoadFromSqlServer2" method, and even less via any search engine.

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.loadfromsqlserver2.aspx

I cannot seem to ever get the method to work; it returns "InvalidCastException: No such interface supported."

Is this code-speak for "does not work at this time" ?

Sample code (add a reference to c:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll)

Dim app As New Microsoft.SqlServer.Dts.Runtime.Application

Dim pkg As Microsoft.SqlServer.Dts.Runtime.Package

Dim cnDatasource As New System.Data.SqlClient.SqlConnection

cnDatasource.ConnectionString = _

"Data Source=SQLOLEDB;SERVER=" & m_Datasource & ";Initial Catalog=msdb;Integrated Security=SSPI"

cnDatasource.Open()

pkg = app.LoadFromSqlServer2(m_PackageFolderPath & m_PackageName, cnDatasource, Nothing)

I am aware of the "LoadFromSqlServer" and "LoadFromDtsServer" methods; I like the idea of the Win-NT authentication (theoretically) available in the "LoadFromSqlServer2" method.

Did you read the first line of that link you sent?

"This method supports the SQL Server 2005 infrastructure and is not intended to be used directly from your code. "

|||

I guess I didn't. I've not met documentation that I wasn't supposed to use.

Thanks for the fact... it would have really been useful.

Does Fuzzy Lookup work with Oracle ?

Sorry, this might be an obvious question, but I can not find anything in the documentation/forum.

I want to use a Fuzzy Lookup between 2 Oracle tables.

I select the Reference Table.

I then switch to the Columns tab, but the "Available Input Columns" and "Available Lookup Columns" lists are always empty.

I have experimented quite a bit, but to no avail. I noticed this on the Reference Table tabpage : "The table maintenance feature requires the installation of a trigger on the reference table". My guess would be that SSIS does not support Oracle for this, but I am not able to find anything in the documentation that it doesn't.

Any answer/pointer greatly appreciated.

Thanks

Jan Vandepitte

Haven't tried it against Oracle, but my first question would be whether you have permission to create tables and triggers in the db.|||

Hi Jan,

The Fuzzy Lookup and Fuzzy Grouping components are SQL Server only.

I'm sure the answer is also in books online somewhere, but the SSIS Connectivity Wiki has a simple table that shows the data provider options for each of our components.

Hope that helps!

~Matt

Documents on redistributing full version

Anyone have a clue where to find documentation on how to distribute/license
the full version of SQL 2000 with an application? Can't seem to find
anything on the /sqlserver site.
thanksI think that below is what you are looking for:
http://www.microsoft.com/sql/howtobuy/aspisv.asp
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"A" <agarrettbNOSPAM@.hotmail.com> wrote in message
news:u%236uvqiqDHA.2584@.TK2MSFTNGP09.phx.gbl...
> Anyone have a clue where to find documentation on how to
distribute/license
> the full version of SQL 2000 with an application? Can't seem to find
> anything on the /sqlserver site.
> thanks
>

Documenting tables/fields - utility?

As part of a project documentation I want to list out the fields of all the tables to say Excel to plug in a description of the field and other notes.

Is there a tool in EM that would facilitate? Or, is there a utility that would work or a SQL script? Any recommendations is greatly appreciated.

Thanks,

PeterI'll never understand what motivates people to want to take DATA from a DATABASE and store it in a SPREADSHEET.
Tables and columns are already enumerated within the database, and a description of each column can be entered through Enterprise Manager.
You can query the system tables to list all the tables with their columns and descriptions and (if you absolutely insist...) export the results to an Excel file.|||Erwin is good for this. Which reminds me I am about a month and a half behind on that.|||Hey - for a blind guy, you sure help me see the light.

Thanks blindman.|||I keep a bottle of hand-sanitizer with me for occasions when a client requires me to open up Excel, but otherwise all the data I deal with stays in databases.|||LOL - I like that line about having to use hand sanitizer...I will be using that one myself.

I did find a quick query syntax at:

http://searchvb.techtarget.com/tip/1,289483,sid8_gci876303,00.html?bucket=ETA

SELECT
table_name=sysobjects.name,
column_name=syscolumns.name,
datatype=systypes.name,
length=syscolumns.length
FROM sysobjects inner JOIN syscolumns ON sysobjects.id = syscolumns.id
inner join systypes on syscolumns.xtype=systypes.xusertype
where sysobjects.xtype='U'
order by sysobjects.name,syscolumns.colid

I altered the above to bring in the description that a user can enter against each field in the tables:

SELECT
table_name=sysobjects.name,
column_name=syscolumns.name,
datatype=systypes.name,
length=syscolumns.length,
descr=sysproperties.value
FROM sysobjects inner JOIN syscolumns ON sysobjects.id = syscolumns.id
inner join systypes on syscolumns.xtype=systypes.xusertype
left join sysproperties on sysproperties.id=syscolumns.id and syscolumns.colid=sysproperties.smallid
where sysobjects.xtype='U'
order by sysobjects.name,syscolumns.colid

This is fine for my immediate needs.|||If you liked that one, you'll love this one ... and it's guarenteed not to become obsolete with sql server upgrades ...


select * from information_schema.columns|||Tom -

Thanks - another good one for quick data generation.

Documenting large numbers of SPs

Hi All,

I have a large number of SPs that I would like to be able to document and provide this documentation to prospective clients. That is, provide them enough information without giving them the source code for the procedures.

I have found that all the parameters are in the sys.parameters table.

But I was wondering. Are the fields that are sent back out of an SP captured and recorded somewhere in the SQL Server catalog?

Is there an easy way to find out what fields are coming out of an SP?

Thanks in Advance

Peter

You may be better served exploring one of the third party documentation tools.

I like ApexSQL's Doc tool.

You can download a fully functional eval version.

|||

Hi Arnie,

thanks for the tip...I'll take a look..

Peter

Documenting and searching a schema

Hi experts,
is there any external tool or feature within SQL Server 2005, which
enables a searchable documentation of schemas?
What I would like to do is to add descriptions to tables, columns and
foreign key relations describing their meaning in detail. By the term
"description" I do not mean a meaningful name, but (where required) a
longer, formatted text. Additional a google-like keyword search would
be nice, to be able to find matching elements, like e.g. all tables or
columns containing "customer" in the description text. The list of
search results should list the matching elements and show the first
few words of the description (very similar to the way google lists its
search results). If an element from the list is choosen, then the full
description should become visible. If the found elements could then be
dragged and dropped directly to a query builder - that would be
perfect!
As I don't think that I'm the first one thinking about enabling
documentation and search on database schemas, there should be tools
already existing for that purpose. But as I don't know any of them -
could you please suggest me some?
Kind regards,
Max
(send.me.all.email@.googlemail.com) writes:
> is there any external tool or feature within SQL Server 2005, which
> enables a searchable documentation of schemas?
> What I would like to do is to add descriptions to tables, columns and
> foreign key relations describing their meaning in detail. By the term
> "description" I do not mean a meaningful name, but (where required) a
> longer, formatted text. Additional a google-like keyword search would
> be nice, to be able to find matching elements, like e.g. all tables or
> columns containing "customer" in the description text. The list of
> search results should list the matching elements and show the first
> few words of the description (very similar to the way google lists its
> search results). If an element from the list is choosen, then the full
> description should become visible. If the found elements could then be
> dragged and dropped directly to a query builder - that would be
> perfect!
> As I don't think that I'm the first one thinking about enabling
> documentation and search on database schemas, there should be tools
> already existing for that purpose. But as I don't know any of them -
> could you please suggest me some?
You could look into SQLDoc from Red Gate (http://www.red-gate.com/). The
tool permits you to enter extended properties per table (not on column
level), and you can then generate a web site or HTML Help from the database.
Since HTML Help is searchable, this may be what you are looking for. You
can download a 14-day eval to have a look.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Get a copy of Doc from ApexSQL (www.apexsql.com).
TheSQLGuru
President
Indicium Resources, Inc.
<send.me.all.email@.googlemail.com> wrote in message
news:1184095671.151380.170660@.o61g2000hsh.googlegr oups.com...
> Hi experts,
> is there any external tool or feature within SQL Server 2005, which
> enables a searchable documentation of schemas?
> What I would like to do is to add descriptions to tables, columns and
> foreign key relations describing their meaning in detail. By the term
> "description" I do not mean a meaningful name, but (where required) a
> longer, formatted text. Additional a google-like keyword search would
> be nice, to be able to find matching elements, like e.g. all tables or
> columns containing "customer" in the description text. The list of
> search results should list the matching elements and show the first
> few words of the description (very similar to the way google lists its
> search results). If an element from the list is choosen, then the full
> description should become visible. If the found elements could then be
> dragged and dropped directly to a query builder - that would be
> perfect!
> As I don't think that I'm the first one thinking about enabling
> documentation and search on database schemas, there should be tools
> already existing for that purpose. But as I don't know any of them -
> could you please suggest me some?
> Kind regards,
> Max
>

Documenting a Database

Hi,
I have designed and developed a database. Now I want to prepare some
documentation so that other developers can continue working on that.
How can I do this? Are there any standard ways to describe the entities and
procedures using some tools or etc.
Thanks in advance,
LeilaHi
With the Enterprise Edition of Visio you can produce reports and diagrams
for your database, other modeling tools will provide similar functions.
You can also add extended properties to document your database such as
http://www.aspfaq.com/show.asp?id=2244
John
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23527A5D7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have designed and developed a database. Now I want to prepare some
> documentation so that other developers can continue working on that.
> How can I do this? Are there any standard ways to describe the entities
> and
> procedures using some tools or etc.
> Thanks in advance,
> Leila
>|||I can't pass this one up. :) How did you design a database without
documentation? Oh, nevermind!!!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uDoASTE7EHA.4040@.TK2MSFTNGP14.phx.gbl...
> Hi
> With the Enterprise Edition of Visio you can produce reports and diagrams
> for your database, other modeling tools will provide similar functions.
> You can also add extended properties to document your database such as
> http://www.aspfaq.com/show.asp?id=2244
> John
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23527A5D7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > I have designed and developed a database. Now I want to prepare some
> > documentation so that other developers can continue working on that.
> > How can I do this? Are there any standard ways to describe the entities
> > and
> > procedures using some tools or etc.
> > Thanks in advance,
> > Leila
> >
> >
>
>

Documentation Tools for SSB?

Does anyone know if there are automated documentation tools around that will produce docs for Service Broker objects?

Thanks,

AndrewM

There is no tool for documentation, but there is one for retrieving a more formal specification (Called service listing). It's called Service Listings Manager and Remus has contributed that to the code gallery. You might want to use that as a starting point to build a doc generator.

Documentation Tool

I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others?
Thanks for the help,
RDA
http://www.aspfaq.com/2209
http://www.aspfaq.com/
(Reverse address to reply.)
"RDA" <anonymous@.discussions.microsoft.com> wrote in message
news:48620959-3C4E-4520-A9B0-CAD19CE70530@.microsoft.com...
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA
|||RDA,
I like ER/Studio from Embarcadero.
http://www.embarcadero.com/products/erstudio/index.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RDA wrote:
> I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others?
> Thanks for the help,
> RDA
|||Consider WT3 - one of the SQL Server Tools applications...
http://www.sqlservertools.us
It may do what you are asking for, as well as a lot more.

Documentation Tool

I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others
Thanks for the help
RDAhttp://www.aspfaq.com/2209
--
http://www.aspfaq.com/
(Reverse address to reply.)
"RDA" <anonymous@.discussions.microsoft.com> wrote in message
news:48620959-3C4E-4520-A9B0-CAD19CE70530@.microsoft.com...
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA|||RDA,
I like ER/Studio from Embarcadero.
http://www.embarcadero.com/products/erstudio/index.html
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RDA wrote:
> I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others?
> Thanks for the help,
> RDA|||Consider WT3 - one of the SQL Server Tools applications..
http://www.sqlservertools.u
It may do what you are asking for, as well as a lot more

Documentation Tool

I was wondering if anyone has a good SQL Server Documentation tool. I have b
een looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone kn
ow of others?
Thanks for the help,
RDAhttp://www.aspfaq.com/2209
http://www.aspfaq.com/
(Reverse address to reply.)
"RDA" <anonymous@.discussions.microsoft.com> wrote in message
news:48620959-3C4E-4520-A9B0-CAD19CE70530@.microsoft.com...
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA|||RDA,
I like ER/Studio from Embarcadero.
http://www.embarcadero.com/products/erstudio/index.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RDA wrote:
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA|||Consider WT3 - one of the SQL Server Tools applications...
http://www.sqlservertools.us
It may do what you are asking for, as well as a lot more.

documentation to install sql 2005 express remotely

Hi all,

I'm just wondering if there is documentation anywhere to help me with installation of SQL 2005 Express on a remote computer. I've set up IIS 6.0 and Windows Server 2003 Web Edition on another computer and am planning to use that for a development server.

Currently I've already installed VWD Express (local computer) and SQL 2005 Express, as well as SQL Query Manager (remote computer). But I seem to be having problems with VWD being able to create databases when i edit the code remotely.

For example when I right-click on "Data Connections" in the "Database Explorer" to create a new database it won't let me. The only way I can do this is to add a connection to a database which I have previously created. And even then there are still problems.

If I set up the database by adding a connection I cannot seem to create stored procedures. The error message I keep getting is "This feature is not supported in Visual Developer".

Is this due to wrong settings whilst installing SQL Express? Or am I just not configuring it right?

Any help on this issue would be greatly appreciated.

Thanks.

I'm not totally up on the capabilities of VWD with regards to database management. There is also the issue of User Instances, which is the default when creating database in VS for many cases. User Instances do not support remote connections, so that would cause problems.

In order to troubleshoot this one, you should simply the scenario by taking VS out of the picture. Use either Managment Studio Express of SQLCmd from your local computer to connect to the remote instance of SQL Express and try to create a database. If that works, try to perfrom some other task against that database. If that works, then the issue is in VS. If you have problems with SSMSE or SQLCmd, then we can look more closely at the SQL issue.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Hi Mike,

As you were saying using Management Studio Express is fine. I can connect to the database remotely and am able to create databases and all that.

The only problem is that I'm currently learning ASP.NET and most of the books utilise VWD Express Edition interface to create, manage and run databases including using the inbuilt (Database Explorer) stored procedures capabilities in VWD. And what they are teaching is to use these locally and not in a remote situation.

I'm just wondering, is there a way to create a stored procedures folder or something similar in SQL Management Express?

I haven't had much experience with MS SQL so please bear with me :)

Thanks for your prompt reply and help.

|||

Stored Procedures are a built-in part of SQL Server, you don't need to create a folder for them. In Management Studio, you should see a folder icon that says Programmability. If you expand that, you will find a place already there for Stored Procedures. When you create a Stored Procedure, they automatically appear in that list, there is no need to specifically put them there.

In order to create a new Stored Procedure in Management Studio you can either right-click on the Stored Procedure "folder" and click the New command, or you can simply open a new query windows against your target database and write a CREATE PROCEDURE script in T-SQL.

Like I mentioned, I think the problem you are facing is related to the default settings of VWD that result in using a User Instance, which only supports a local connection. All of the VS Express products are designed to be used for local development by default. I don't know any specifics about using them to develop against a remote server, other than the fact that you can't use User Instances. As far as I know, there is no way to turn off the default use of User Instances in VS Express products, but you can modify the connection strings manually once they've been created to remove the keyword. This would likely require you to move the database from your local system to the remote server and attach the database there as well.

I would suggest you check out http://forums.asp.net/ to ask more specific question about VWD functionaltiy. I'm out of my element when it comes to web development and VWD.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike,

Thanks for that. I'll try and post up some questions on the asp.net forums.

documentation to install sql 2005 express remotely

Hi all,

I'm just wondering if there is documentation anywhere to help me with installation of SQL 2005 Express on a remote computer. I've set up IIS 6.0 and Windows Server 2003 Web Edition on another computer and am planning to use that for a development server.

Currently I've already installed VWD Express (local computer) and SQL 2005 Express, as well as SQL Query Manager (remote computer). But I seem to be having problems with VWD being able to create databases when i edit the code remotely.

For example when I right-click on "Data Connections" in the "Database Explorer" to create a new database it won't let me. The only way I can do this is to add a connection to a database which I have previously created. And even then there are still problems.

If I set up the database by adding a connection I cannot seem to create stored procedures. The error message I keep getting is "This feature is not supported in Visual Developer".

Is this due to wrong settings whilst installing SQL Express? Or am I just not configuring it right?

Any help on this issue would be greatly appreciated.

Thanks.

I'm not totally up on the capabilities of VWD with regards to database management. There is also the issue of User Instances, which is the default when creating database in VS for many cases. User Instances do not support remote connections, so that would cause problems.

In order to troubleshoot this one, you should simply the scenario by taking VS out of the picture. Use either Managment Studio Express of SQLCmd from your local computer to connect to the remote instance of SQL Express and try to create a database. If that works, try to perfrom some other task against that database. If that works, then the issue is in VS. If you have problems with SSMSE or SQLCmd, then we can look more closely at the SQL issue.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Hi Mike,

As you were saying using Management Studio Express is fine. I can connect to the database remotely and am able to create databases and all that.

The only problem is that I'm currently learning ASP.NET and most of the books utilise VWD Express Edition interface to create, manage and run databases including using the inbuilt (Database Explorer) stored procedures capabilities in VWD. And what they are teaching is to use these locally and not in a remote situation.

I'm just wondering, is there a way to create a stored procedures folder or something similar in SQL Management Express?

I haven't had much experience with MS SQL so please bear with me :)

Thanks for your prompt reply and help.

|||

Stored Procedures are a built-in part of SQL Server, you don't need to create a folder for them. In Management Studio, you should see a folder icon that says Programmability. If you expand that, you will find a place already there for Stored Procedures. When you create a Stored Procedure, they automatically appear in that list, there is no need to specifically put them there.

In order to create a new Stored Procedure in Management Studio you can either right-click on the Stored Procedure "folder" and click the New command, or you can simply open a new query windows against your target database and write a CREATE PROCEDURE script in T-SQL.

Like I mentioned, I think the problem you are facing is related to the default settings of VWD that result in using a User Instance, which only supports a local connection. All of the VS Express products are designed to be used for local development by default. I don't know any specifics about using them to develop against a remote server, other than the fact that you can't use User Instances. As far as I know, there is no way to turn off the default use of User Instances in VS Express products, but you can modify the connection strings manually once they've been created to remove the keyword. This would likely require you to move the database from your local system to the remote server and attach the database there as well.

I would suggest you check out http://forums.asp.net/ to ask more specific question about VWD functionaltiy. I'm out of my element when it comes to web development and VWD.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike,

Thanks for that. I'll try and post up some questions on the asp.net forums.

Documentation to get started

What is the best online documentation either on the Web or installed
with
SQL Server that I could use to get started? I want to jump in and
start
creating tables, etc for applications.

Also, what is the most recommended text for converting my DBA
experience from other database to SQL Server.

Thanks
Bill.Books Online, SQL Server's official documentation installed
with SQL Server, is a good place to start. There are many
good SQL Server books. One of them which I like is:

The Guru's Guide to Transact-SQL by Ken Henderson
(publisher: Addison Wesley).

Note that this is not an official endorsement!
--
Arun Marathe
Program Manager
SQL Server Query Processor
Microsoft Corporation

Disclaimers:
(1) This posting is provided "AS IS" with no warranties, and confers no
rights.
(2) Use of included script samples are subject to the terms specified at:
http://www.microsoft.com/info/cpyright.htm

"Bill" <bill_ralenkotter@.yahoo.com> wrote in message
news:96254b32.0309040631.21c23b1b@.posting.google.c om...
> What is the best online documentation either on the Web or installed
> with
> SQL Server that I could use to get started? I want to jump in and
> start
> creating tables, etc for applications.
> Also, what is the most recommended text for converting my DBA
> experience from other database to SQL Server.
> Thanks
> Bill.|||Bill

As you will soon find there are dozens of useful SQL Server Web sites.
These are two of the best ones to help get you started.

http://www.microsoft.com/technet/ne...rver&frame=true

http://www.sql-server-performance.com/

Hope these help

John|||Thanks for the links I will continue to look at them.

One thinkn in particular that I am after are instructions
for connecting to the DB right after it is installed.
I think there is a test database and I want to log into that.
I am probably not seeing these instructions on the installed
docs?

Thanks
Bill.

documentation on SQL OLE methods...Where to find?

I've seen a few examples in BOL and various websites where sp_OAMethod is
used to generates scripts, return rows, etc. For example:
SET @.exec_str = 'Databases("'+@.dbname+'").Tables("'+RTRIM(UPPER(@.tbname))+'").Script(74077,"
'+ @.filename +'")'
EXEC @.hr = sp_OAMethod @.object, @.exec_str, @.return OUT
I can't seem to find any documentation that explains the possible methods
(like databases().Tables().Script).
Can someone point me to where I could find a list of these methods?
Thanks in advancesp_OACreate invokes an extermal program that has a COM OO interface.
The documentation you're looking for will reside with whichever external COM
application you're referring to.
You haevn't given us the name of the particular application you're looking
for in your post, so it's a bit hard to answer this. Your post only gives us
information on a method - perhaps if you go back to whever you got that code
snippet from & give us the part that has "sp_OACreate" in it, we may be able
to help you further.
Regards,
Greg Linwood
SQL Server MVP
"TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
news:#$OwJjrsDHA.1680@.TK2MSFTNGP12.phx.gbl...
> I've seen a few examples in BOL and various websites where sp_OAMethod is
> used to generates scripts, return rows, etc. For example:
> SET @.exec_str =>
'Databases("'+@.dbname+'").Tables("'+RTRIM(UPPER(@.tbname))+'").Script(74077,"
> '+ @.filename +'")'
> EXEC @.hr = sp_OAMethod @.object, @.exec_str, @.return OUT
> I can't seem to find any documentation that explains the possible methods
> (like databases().Tables().Script).
> Can someone point me to where I could find a list of these methods?
> Thanks in advance
>|||Hi Greg,
Thanks for the reply. Here's the sp_OACreate statement:
EXEC @.hr = sp_OACreate 'SQLDMO.SQLServer', @.object OUT
Thanks,
Tom
"Greg Linwood" <g_linwoodremovethisbeforeemailingme@.hotmail.com> wrote in
message news:uIDLvwrsDHA.2416@.TK2MSFTNGP10.phx.gbl...
> sp_OACreate invokes an extermal program that has a COM OO interface.
> The documentation you're looking for will reside with whichever external
COM
> application you're referring to.
> You haevn't given us the name of the particular application you're looking
> for in your post, so it's a bit hard to answer this. Your post only gives
us
> information on a method - perhaps if you go back to whever you got that
code
> snippet from & give us the part that has "sp_OACreate" in it, we may be
able
> to help you further.
> Regards,
> Greg Linwood
> SQL Server MVP
> "TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
> news:#$OwJjrsDHA.1680@.TK2MSFTNGP12.phx.gbl...
> > I've seen a few examples in BOL and various websites where sp_OAMethod
is
> > used to generates scripts, return rows, etc. For example:
> > SET @.exec_str => >
>
'Databases("'+@.dbname+'").Tables("'+RTRIM(UPPER(@.tbname))+'").Script(74077,"
> > '+ @.filename +'")'
> > EXEC @.hr = sp_OAMethod @.object, @.exec_str, @.return OUT
> >
> > I can't seem to find any documentation that explains the possible
methods
> > (like databases().Tables().Script).
> >
> > Can someone point me to where I could find a list of these methods?
> >
> > Thanks in advance
> >
> >
>|||Most COM (or Automation) objects come with their own
documentation. For instance, the object hierarchy of SQL-
DMO can be found in SQL Server Books Online. If you need
to interact with an object hierarchy that doesn't seem to
have online/printed documentation, you can try tools such
as OLE-COM Object Viewer that comes with NT Resource kit.
The object viewer allows you browse the object hierarchy
and see all the objects, methods, and proerties.
By the way, if you can stay away from sp_OAxxx stuff, stay
away from it. It's pretty ugly and you can't import the
symbolic constants.
Linchi
>--Original Message--
>I've seen a few examples in BOL and various websites
where sp_OAMethod is
>used to generates scripts, return rows, etc. For example:
>SET @.exec_str =>'Databases("'+@.dbname+'").Tables("'+RTRIM(UPPER(@.tbname))
+'").Script(74077,"
>'+ @.filename +'")'
>EXEC @.hr = sp_OAMethod @.object, @.exec_str, @.return OUT
>I can't seem to find any documentation that explains the
possible methods
>(like databases().Tables().Script).
>Can someone point me to where I could find a list of
these methods?
>Thanks in advance
>
>.
>

Documentation of the Tables in SQL Server

Hi all
I have 15 tables in my database and I want to create a pdf file with description about all the columns of these tables(Data Model)
Few questions
How can I get all the column names in the excel or pdf file?
Is there any tool which can give me the output template for these columns and then I just have to fill the description for each column?
ThanksYou can query the Information _Schema tables to get a listing of tables and their columns.|||Did you ask your dba?|||Did you ask your dba?

Better yet ... did you buy your dba lunch?|||My preference would be to create a script that will create the tables (complete with constraints, etc) and then comment that script liberally. You can use Visual Studio, SQL Enterprise Mangler, or SQL-DMO to make the script if you don't already have one.

Once you've done this, check the fully commented script into source code control too!

-PatP|||Thanks guys for the responses
Here I am talking about an already built system and I am trying to document the database|||You can look on Red Gate i think they have a tool for that|||You can look on Red Gate i think they have a tool for that

so do I, and it's better than redgate's. see the link in my sig. :)|||Thanks
I wish there was any free/open source solution!|||Pat's solution (post #5) is free. I have a binder on my desk that's full of well commented "script" files of all my table definitions. Columns, indexes, triggers, etc. Every time I change a table, I regenerate the script and put new comments in. The extra 5 minutes is worth the effort.|||I don't consider a pile of commented source files as documentation. Would the the source code to SQL Server (heavily commented) tell you how to use it? Not really.

There are some free ones out there (but you get what you pay for). for example:

http://www.codeplex.com/datadictionary

Documentation of snapshot isolation level in data source

Hello all,

I was wondering if there's somewhere good documentation of the semantics of isolation level in a data source in an Analysis Services project and how the different isolation levels affect the processing of Analysis Services database. I don't mean the semantics of differerent isolation levels in SQL server, those are well documented, but what the isolation level actually means in context of an Analysis Services data source.

I'm interested in using snapshot isolation level so that when processing the Analysis Services database all the data for the Analysis Services objects would be got using a snapshot of the SQL Server database. I wonder if this is possible. There's additionally the "Maximum number of connections"-property. I assume that when processing the Analysis Services multiple connections are made to SQL server and if each of those connections use snapshot isolation level, there's no guarantee the snapshots contain the same data.

My actual problem is that the data may change in the SQL server database while processing Analysis Services database. This causes Analysis Services processing failures sometimes, since a value in the database may be found in one dimension, but not in another one.

Any ideas?

r,

J

This doesn't directly answer your question, but it might be easier to support and maintain. Try setting a flag on the records in the data warehouse tables. The flag would indicate whether or not the record was available for upload into SSAS. The flag would be set to 1 (where it was currently set to 0) at the top of the run. Data entering the tables during the run would have the flag set to the default of 0. Your queries would have logic to select just those records with the flag set to 1.

Otherwise, you can follow the steps provided in this KB article to setup/configure/use snapshot isolation:

http://support.microsoft.com/kb/919160

Good luck,

Bryan