Downloading sample databases

I am trying to download the sample databases for SQL Server 2005 and SQL
Server 2008.
As I often find to be the case, http://www.codeplex.com is not available. I
have reported this on the codeplex forums in the past. It does not appear
that there has ever been an improvement in the availability of this site.
When I need something from that site, it seems to be unavailable more than it
is available.
Here is the result of running tracert on the site, showing that the problem
is internal within Microsoft's own network:
P:\>tracert www.codeplex.com
Tracing route to www.codeplex.com [207.46.208.126]
over a maximum of 30 hops:
1 <1 ms 1 ms <1 ms myrouter-name is company
confidential[xxx.xxx.xxx.xxx]
2 <1 ms <1 ms <1 ms myfirewall-name is company
confidential[xxx.xxx.xxx.xxx]
3 1 ms <1 ms 1 ms myrouter-name is company
confidential[xxx.xxx.xxx.xxx]
4 10 ms 10 ms 9 ms POS1-3.GW6.DFW9.ALTER.NET [xxx.xxx.xxx.xxx]
5 12 ms 11 ms 11 ms 158.at-5-0-0.XR1.DFW9.ALTER.NET
[xxx.xxx.xxx.xxx]
6 13 ms 11 ms 9 ms 0.so-2-1-0.XT3.DFW9.ALTER.NET [152.63.101.249]
7 75 ms 75 ms 76 ms 0.so-7-0-0.XL1.SEA4.ALTER.NET [152.63.104.194]
8 76 ms 75 ms 75 ms 0.so-6-0-0.GW1.SEA4.ALTER.NET [152.63.107.249]
9 76 ms 75 ms 76 ms msft-oc48.customer.alter.net [157.130.177.254]
10 77 ms 78 ms 76 ms ge-5-2-0-54.tuk-64cb-1a.ntwk.msn.net
[207.46.45.
69]
11 * * * Request timed out.
12 * 79 ms 76 ms po1.tuk-6ns-mcs-2a.ntwk.msn.net [207.46.39.33]
13 * * * Request timed out.
14 * po1.tuk-6ns-mcs-2b.ntwk.msn.net [207.46.39.45] reports:
Destinati
on net unreachable.
Trace complete.
Firstly, I would like to suggest/request that the important developer
downloads that have been moved to codeplex.com, such as enterprise library
and sql server sample databases, be made available in the MSDN subscriber
downloads.
Secondly, and more important right now, is that I need those downloads and
the site is not available. I am trying to understand some code from MSDN and
BOL that uses the sample databases. Before I can understand that code so
that I can use the information from BOL in the task I am working on today, I
need to have the sample databases for SQL Server 2005 for certain and,
hopefully, SQL Server 2008. As a MSDN subscriber, please tell me where I can
get those downloads other than the unavailable codeplex.com site.
Thanks,
Dale
Thank you for your uresponse, Gail. I did finally get the samples
downloaded. I attached them to my developer version of SQL Server 2005 by
copying the mdf and ldf files from the default installation in Express
Edition.
*Big sigh of relief*... That was two hours waisted. It probably would not
have been so frustrating if the issues with CodePlex availability didn't
happen so often.
Thanks again for your quick response.
Dale
"Gail Erickson [MS]" wrote:

> Hi Dale,
> I've forwarded your post to the samples team so that they are aware of your
> on-going problem with Codeplex. I notice that you provided similar feedback
> on the Sample Databases page in Codeplex
> (http://www.codeplex.com/MSFTDBProdSamples) today. I assume that means you
> were finally able to download the sample databases. If that's not the case,
> let me know.
> If you have a version of SQL Server 2005 other than the Express or Compact
> editions, you can install the sample databases by re-running setup.See the
> section "Installation After Setup" in the BOL topic "Running Setup to
> Install AdventureWorks Sample Databases and Samples". Cut/paste this URL
> to get to that topic:
> ms-help://sql90/instsql9/html/8c4c2af8-f2ed-4559-b5d2-984a9f7ce5ca.htm
> Right now there is no significant difference between AdventureWorks for 2005
> and AdventureWorks for 2008, so you should be able to use the database for
> either versions of SQL Server.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
> "Dale" <dale0973@.nospam.nospam> wrote in message
> news:83FEED8D-9360-4CF8-BEFC-4AC632E5B077@.microsoft.com...
>
>
sql

Downloading files from sql server

I am looking for some material for downloading documents from sqlserver. I can upload documents in my app but i would also like todownload those files too.
Thank you
My normal reply to this question is to search this SQL Server &MSDE forum for the word BLOB. But unfortunately I see theindexing of posts is not yet complete and this is not turning up theresults I would hope for.
TryLoad Images from and Save Images to a Database andHow To Read and Write BLOB Data by Using ADO.NET with Visual C# .NET.
|||yeah i've been finding it quite hard to find anything ongoogle/internet. And i need to do it asp.net, i've got the uploading ofthe files to work, its just viewing the files which is more challengingit seems.

Download the file stored in sqlserver table as image datatype using asp.net 2.0

I am using Asp.net 2.0 with C# and sql server 2000. I need to download the file which is stored in sql server database table as image datatype. So I need to download from cs page.

Pls reply,

Arun.

Here's a good article on storing and retrieving binary data with asp.net 2.0
http://www.beansoftware.com/ASP.NET-Tutorials/Binary-Files-To-Database.aspx

|||

Hi,

Consider, you have query like

select files,filename,filesize,fileext from filesintable where id=1

that file on dar[0] as image datatype.

while (dar.Read())
{
bFile = (byte[])dar[0];
Response.AddHeader("Content-Disposition", "attachment; filename=" +dar[1].ToString());

switch (dar[3].ToString())
{
case "ask":
Response.ContentType = "video/x-ms-asf";
break;
case "avi":
Response.ContentType = "video/avi";
break;
case "doc":
Response.ContentType = "application/msword";
break;
case "zip":
Response.ContentType = "application/zip";
break;
case "xls":
Response.ContentType = "application/vnd.ms-excel";
break;
case "ppt":
Response.ContentType = "application/vnd.ms-powerpoint";
break;
case "gif":
Response.ContentType = "image/gif";
break;
case "jpg":
case "jpeg":
Response.ContentType = "image/jpeg";
break;
case "wav":
Response.ContentType = "audio/wav";
break;
case "mp3":
Response.ContentType = "audio/mpeg3";
break;
case "mpg":
case "mpeg":
Response.ContentType = "video/mpeg";
break;
case "rtf":
Response.ContentType = "application/rtf";
break;
case "htm":
case "html":
Response.ContentType = "text/html";
break;
case "asp":
Response.ContentType = "text/asp";
break;
case "pdf":
Response.ContentType = "application/pdf";
break;
default:
Response.ContentType = "application/octet-stream";
break;
}
Response.BinaryWrite(bFile);

}

It works fine.

Download the data from ftpserver to sqlserver

Hi,

It would be appreciated if anyone can solve my problem.

hwz going ur end .its a new assignment .i've to get data from ftpserver and download the into sqlserver.

I tried in 3ways .
1)With bcp command
C:\MSSQL7\Binn>
bcp master..BIBDATA in c:\BIB20031006.TXT -fc:\MSSQL7\Binn\bib52.fmt -SJAVADEV2-PC-NJ -Usa -P
2)dts (data tranformation services)
3)with java pg

I tried with bcp command i downloaded 14000 records in a table ABDATA(It has 4 fields only) but I couldn't download properly with
BIBDATA(It has 52 fields).It has 70000 records.I'm able to download only 155 records.That is the pb.

here i'm sending java files too.can u pls try locally in ur machine and give me reply immediately.

C:\java MyMainFTP
Connecting to ftp://mednewd:med1010newd@.ftp.mattmccoy.com//AB20031021.txt
File AB20031021.txt is Downloading
File AB20031021.txt downloaded
Connecting to ftp://mednewd:med1010newd@.ftp.mattmccoy.com//AV20031021.txt
File AV20031021.txt is Downloading
File AV20031021.txt downloaded
Connecting to ftp://mednewd:med1010newd@.ftp.mattmccoy.com//CA20031021.txt
File CA20031021.txt is Downloading
File CA20031021.txt downloaded
Connecting to ftp://mednewd:med1010newd@.ftp.mattmccoy.com//BIB20031021.txt
File BIB20031021.txt is Downloading
File BIB20031021.txt downloaded
I am going to read next line ,Line Number is........0
iCount......1 Number of Tokens :79
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]The name '
BD' is not permitted in this context. Only constants, expressions, or variables
allowed here. Column names are not permitted.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java :3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcSt atement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcO dbcStatement.java:2
53)
at MyMainFTP.insertToDatabase(MyMainFTP.java:264)
at MyMainFTP.main(MyMainFTP.java:121)
I am going to read next line ,Line Number is........1You don't mention your results with DTS. Was there a problem?

Downgrading SQLServer to MSDE

Hi,
I am pretty new to MSDE and am just researching options for writing a .NET
version of a desktop application (currently VB6 / Access).
There is a web version of our product available already which has a SQL
Server backend.
I am figuring that I will use MSDE so I can use all their Stored procedures
and as much code of theirs as possible.
What I am wondering is if I can get downgrade from SQL Server to MSDE ?
There's lots of information about upgrading, but nothing about downgrading.
Thanks
Sanj
hi,
Sanjit Suchak wrote:
> Hi,
> I am pretty new to MSDE and am just researching options for writing a
> .NET version of a desktop application (currently VB6 / Access).
> There is a web version of our product available already which has a
> SQL Server backend.
> I am figuring that I will use MSDE so I can use all their Stored
> procedures and as much code of theirs as possible.
> What I am wondering is if I can get downgrade from SQL Server to MSDE
> ? There's lots of information about upgrading, but nothing about
> downgrading.
downgrading is a viable solution as long as you take into consideration all
relevant MSDE limitations..
2gb database size, limited replication support, no OLAP features, no
Reporting Services... and limited number of users scenarios... these are the
most relevant of them in my opinion... but the core features are all
available...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

downgrade lisences

Hi,
Is there a way to downgrade license for already installed and in use SQL
Server like:
1. Downgrade Enterprise Edition license from processor based to say 25 CAL
based.
2. Downgrade Enterprise Edition SQL Server to Standard Edition?
OR would the only solution be uninstall-install.
ThanksHi,
1. Downgrade Enterprise Edition license from processor based to say 25 CAL
based.
There is a undocumented was to do this by editing the registry.
You have to edit the registry using regedt32 :- (Not recommended at all)
\\Hkey_Local_Machine\Software\_Microsoft
\Microsoft SQL
Server\80\MSSQLLicenseInfo\MSS_QL8.00\Mode key\
Change the value to 0 and you get both options available.
2. Downgrade Enterprise Edition SQL Server to Standard Edition?
You can upgrade from a lower edition to higher edition. But to downgrade an
edition is not possible directly. The only solution is
to take a backup of all databases , Installl standard edition , latest
service pack and restore the databases back.
Thanks
hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:B300ACED-C12F-44EE-9F91-67121F87F46F@.microsoft.com...
> Hi,
> Is there a way to downgrade license for already installed and in use SQL
> Server like:
> 1. Downgrade Enterprise Edition license from processor based to say 25 CAL
> based.
> 2. Downgrade Enterprise Edition SQL Server to Standard Edition?
> OR would the only solution be uninstall-install.
> Thanks
>

downgrade lisences

Hi,
Is there a way to downgrade license for already installed and in use SQL
Server like:
1. Downgrade Enterprise Edition license from processor based to say 25 CAL
based.
2. Downgrade Enterprise Edition SQL Server to Standard Edition?
OR would the only solution be uninstall-install.
Thanks
Hi,
1. Downgrade Enterprise Edition license from processor based to say 25 CAL
based.
There is a undocumented was to do this by editing the registry.
You have to edit the registry using regedt32 :- (Not recommended at all)
\\Hkey_Local_Machine\Software\XMicrosoft\Microsoft SQL
Server\80\MSSQLLicenseInfo\MSSXQL8.00\Mode key\
Change the value to 0 and you get both options available.
2. Downgrade Enterprise Edition SQL Server to Standard Edition?
You can upgrade from a lower edition to higher edition. But to downgrade an
edition is not possible directly. The only solution is
to take a backup of all databases , Installl standard edition , latest
service pack and restore the databases back.
Thanks
hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:B300ACED-C12F-44EE-9F91-67121F87F46F@.microsoft.com...
> Hi,
> Is there a way to downgrade license for already installed and in use SQL
> Server like:
> 1. Downgrade Enterprise Edition license from processor based to say 25 CAL
> based.
> 2. Downgrade Enterprise Edition SQL Server to Standard Edition?
> OR would the only solution be uninstall-install.
> Thanks
>

Down-grade

How easy is it to down-grade SQLServer 2000 from Enterprise edition to
Standard edition? Are there any risks involved? If yes, what are these
risks and what could I do to minimise them?
See if this helps:
INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to SQL
2000 Standard Edition
http://support.microsoft.com/default...61&Product=sql
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Griff" <Howling@.The.Moon> wrote in message
news:OKBA8UhfEHA.3988@.tk2msftngp13.phx.gbl...
How easy is it to down-grade SQLServer 2000 from Enterprise edition to
Standard edition? Are there any risks involved? If yes, what are these
risks and what could I do to minimise them?
|||Hi Vyas
If I have read this topic correctly, then this is for moving databases from
one SQLServer running Enterprise version to another SQLServer running
standard edition.
I'm more interested in physically down-grading an existing server.
Griff
|||Hi Griff,
You need to remove sql enterprise edition and install sql standard edition.
You could do the below steps:-
1. Backup and databases (can be used if attach fails)
2. detach all the databases from sql enterrise edition
3. Remove sql enterprise edition and install sql standard with same
directory structure
4. Apply the same service pack level
5. Attach the MDF and LDF files back in standard edition.
If attach fails you could restore the database using the backup files
performed in step-1
FYI, I have never done this type of downgrade.
Thanks
Hari
MCDBA
"Griff" <Howling@.The.Moon> wrote in message
news:uv6DZAifEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi Vyas
> If I have read this topic correctly, then this is for moving databases
from
> one SQLServer running Enterprise version to another SQLServer running
> standard edition.
> I'm more interested in physically down-grading an existing server.
> Griff
>
|||Hari Prasad wrote:
> Hi Griff,
> You need to remove sql enterprise edition and install sql standard
> edition.
> You could do the below steps:-
> 1. Backup and databases (can be used if attach fails)
> 2. detach all the databases from sql enterrise edition
> 3. Remove sql enterprise edition and install sql standard with same
> directory structure
> 4. Apply the same service pack level
> 5. Attach the MDF and LDF files back in standard edition.
> If attach fails you could restore the database using the backup files
> performed in step-1
> FYI, I have never done this type of downgrade.
Although I've not downgraded systems like this, I've never had a problem
restoring databases on SQL 2000 Personal, even ones created in Enterprise
Edition.
John.

Down-grade

How easy is it to down-grade SQLServer 2000 from Enterprise edition to
Standard edition? Are there any risks involved? If yes, what are these
risks and what could I do to minimise them?See if this helps:
INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to SQL
2000 Standard Edition
http://support.microsoft.com/defaul...361&Product=sql
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Griff" <Howling@.The.Moon> wrote in message
news:OKBA8UhfEHA.3988@.tk2msftngp13.phx.gbl...
How easy is it to down-grade SQLServer 2000 from Enterprise edition to
Standard edition? Are there any risks involved? If yes, what are these
risks and what could I do to minimise them?|||Hi Vyas
If I have read this topic correctly, then this is for moving databases from
one SQLServer running Enterprise version to another SQLServer running
standard edition.
I'm more interested in physically down-grading an existing server.
Griff|||Hi Griff,
You need to remove sql enterprise edition and install sql standard edition.
You could do the below steps:-
1. Backup and databases (can be used if attach fails)
2. detach all the databases from sql enterrise edition
3. Remove sql enterprise edition and install sql standard with same
directory structure
4. Apply the same service pack level
5. Attach the MDF and LDF files back in standard edition.
If attach fails you could restore the database using the backup files
performed in step-1
FYI, I have never done this type of downgrade.
Thanks
Hari
MCDBA
"Griff" <Howling@.The.Moon> wrote in message
news:uv6DZAifEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi Vyas
> If I have read this topic correctly, then this is for moving databases
from
> one SQLServer running Enterprise version to another SQLServer running
> standard edition.
> I'm more interested in physically down-grading an existing server.
> Griff
>|||Hari Prasad wrote:
> Hi Griff,
> You need to remove sql enterprise edition and install sql standard
> edition.
> You could do the below steps:-
> 1. Backup and databases (can be used if attach fails)
> 2. detach all the databases from sql enterrise edition
> 3. Remove sql enterprise edition and install sql standard with same
> directory structure
> 4. Apply the same service pack level
> 5. Attach the MDF and LDF files back in standard edition.
> If attach fails you could restore the database using the backup files
> performed in step-1
> FYI, I have never done this type of downgrade.
Although I've not downgraded systems like this, I've never had a problem
restoring databases on SQL 2000 Personal, even ones created in Enterprise
Edition.
John.sql

Down-grade

How easy is it to down-grade SQLServer 2000 from Enterprise edition to
Standard edition? Are there any risks involved? If yes, what are these
risks and what could I do to minimise them?See if this helps:
INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to SQL
2000 Standard Edition
http://support.microsoft.com/default.aspx?scid=kb;en-us;268361&Product=sql
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Griff" <Howling@.The.Moon> wrote in message
news:OKBA8UhfEHA.3988@.tk2msftngp13.phx.gbl...
How easy is it to down-grade SQLServer 2000 from Enterprise edition to
Standard edition? Are there any risks involved? If yes, what are these
risks and what could I do to minimise them?|||Hi Vyas
If I have read this topic correctly, then this is for moving databases from
one SQLServer running Enterprise version to another SQLServer running
standard edition.
I'm more interested in physically down-grading an existing server.
Griff|||Hi Griff,
You need to remove sql enterprise edition and install sql standard edition.
You could do the below steps:-
1. Backup and databases (can be used if attach fails)
2. detach all the databases from sql enterrise edition
3. Remove sql enterprise edition and install sql standard with same
directory structure
4. Apply the same service pack level
5. Attach the MDF and LDF files back in standard edition.
If attach fails you could restore the database using the backup files
performed in step-1
FYI, I have never done this type of downgrade.
Thanks
Hari
MCDBA
"Griff" <Howling@.The.Moon> wrote in message
news:uv6DZAifEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi Vyas
> If I have read this topic correctly, then this is for moving databases
from
> one SQLServer running Enterprise version to another SQLServer running
> standard edition.
> I'm more interested in physically down-grading an existing server.
> Griff
>|||Hari Prasad wrote:
> Hi Griff,
> You need to remove sql enterprise edition and install sql standard
> edition.
> You could do the below steps:-
> 1. Backup and databases (can be used if attach fails)
> 2. detach all the databases from sql enterrise edition
> 3. Remove sql enterprise edition and install sql standard with same
> directory structure
> 4. Apply the same service pack level
> 5. Attach the MDF and LDF files back in standard edition.
> If attach fails you could restore the database using the backup files
> performed in step-1
> FYI, I have never done this type of downgrade.
Although I've not downgraded systems like this, I've never had a problem
restoring databases on SQL 2000 Personal, even ones created in Enterprise
Edition.
John.

doubt about sqlserver data types

I'm working with sqlserver express 2005, and I have a lot of doubts about what sqlserver data types use. More exactly my doubt is about text types... nchar, nvarchar, varchar... what are the differences?

thanks.::More exactly my doubt is about text types... nchar, nvarchar, varchar... what are the
::differences?

I really hate to tell you, but there is a documentation for SQL Server that has exact definitions of every data type.

Doubt about SQL Server

I need an application to obtain the databases names from my SQL
Server, using Visual Basic 6.0.
Can somebody hel me?(aguzmanc@.gmail.com) writes:

Quote:

Originally Posted by

I need an application to obtain the databases names from my SQL
Server, using Visual Basic 6.0.
Can somebody hel me?

SELECT name FROM master..sysdatabases -- SQL 2000 or earlier
SELECT name FROM sys.databases -- SQL 2005.

Or what is you want help with?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Dotnet Code can be run in SQLServer in 2005-WHY?

Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
ShyamSee if this helps:
http://msdn.microsoft.com/library/d...
lrguidance.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam|||Hi Vyas
If I remember well you have promised us to put some .NET code examples on
your site some time ago :-)
We are still waiting for....:-)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> See if this helps:
>

> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. [url]http://vyaskn.tripod.com/" target="_blank">http://msdn.microsoft.com/library/d...skn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>|||Ill keep them up on www.sqlserver2005.de domain is still moving to another
provider :-(
Cheers, Jens.
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:eSYnjj7eFHA.256@.TK2MSFTNGP14.phx.gbl...
> Hi Vyas
> If I remember well you have promised us to put some .NET code examples on
> your site some time ago :-)
> We are still waiting for....:-)
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> http://msdn.microsoft.com/library/d...clrguidance.asp
>|||Hi Vyas,
Thanks for the Link.But,it gives a better picture
I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me i
n
this regard,it would bemuch appreciated. Thanks in advance.Let me know if an
y
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:

> See if this helps:
> http://msdn.microsoft.com/library/d...clrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>

Dotnet Code can be run in SQLServer in 2005-WHY?

Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam
See if this helps:
http://msdn.microsoft.com/library/de...lrguidance.asp
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam
|||Hi Vyas
If I remember well you have promised us to put some .NET code examples on
your site some time ago :-)
We are still waiting for....:-)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> See if this helps:
>
http://msdn.microsoft.com/library/de...lrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
|||Ill keep them up on www.sqlserver2005.de domain is still moving to another
provider :-(
Cheers, Jens.
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:eSYnjj7eFHA.256@.TK2MSFTNGP14.phx.gbl...
> Hi Vyas
> If I remember well you have promised us to put some .NET code examples on
> your site some time ago :-)
> We are still waiting for....:-)
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> http://msdn.microsoft.com/library/de...lrguidance.asp
>
|||Hi Vyas,
Thanks for the Link.But,it gives a better picture
I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me in
this regard,it would bemuch appreciated. Thanks in advance.Let me know if any
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:

> See if this helps:
> http://msdn.microsoft.com/library/de...lrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>

Dotnet Code can be run in SQLServer in 2005-WHY?

Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
ShyamSee if this helps:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam|||Hi Vyas
If I remember well you have promised us to put some .NET code examples on
your site some time ago :-)
We are still waiting for....:-)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> See if this helps:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>|||I´ll keep them up on www.sqlserver2005.de domain is still moving to another
provider :-(
Cheers, Jens.
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:eSYnjj7eFHA.256@.TK2MSFTNGP14.phx.gbl...
> Hi Vyas
> If I remember well you have promised us to put some .NET code examples on
> your site some time ago :-)
> We are still waiting for....:-)
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> See if this helps:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
>> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
>> Hi,
>> I had recently undergone training in YUKON.As the first class begun,i
>> came
>> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
>> Server.I was surprised by this. My trainer answered that,it was due to
>> performance,scalability and many other "ABILITY" terms...
>> Could someone please give me better answers on this as to why there is a
>> necesary to run dotnet code inside SQL Server? Any article/URL would be
>> appreciated greatly.
>> Thanks,
>> Shyam
>>
>|||Hi Vyas,
Thanks for the Link.But,it gives a better picture :)
I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me in
this regard,it would bemuch appreciated. Thanks in advance.Let me know if any
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:
> See if this helps:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>

Dose sqlserver 2000 support Array type?

Any one know about it?NO|||No, there is none (builtin) Sure you can define your own type with the new SQL Server 2005 but there is array type.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||Can't you just use a table with one column as an array? You could create a table variable in this way that would act like an array, maybe add an identity column which would be your index, and the second column would be your data column. This is not an array, but can be used like one, for example you could iterate through it with a cursor or a while loop.|||Alternatively, use a large varchar, and biuld a string of your array elements, delimitering them with a set char, then use a while loop and CHARINDEX() to iterate through the elements.|||

There is no array type. Some of the other posters mentioned the work-arounds.

We'd be grateful if you could take a few moments and tell us what you're trying to do.

Thanks

|||You can use this function I posted some time ago:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=320221&SiteID=1

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

domain user or local system account ?

Hello,
My server is part of a W2K domain. What do you advice me as account to
run my SQL*Server, service started with a domain user account or as
local system ?

I need advices from a security point of view.

Thank's in advanceDepends on your requirements...

First, I would personally never recommend running SQL in a production
environment as Local System.

If the SQL proccess will ever need to connect to file shares on other
machines (like to backup data to remote location etc...) then you can either
use a domain account, or use local accounts with matching usernames and
passwords on the SQL server and any machine it may connect to.

If your SQL proccess will never connect to File shares, or similar resources
on the network, then you should run it with a Local User account on the box.

But of course, this is just my opinion.

GL

"Kona" <kona_iron@.yahoo.fr> wrote in message
news:a1de658a.0404191607.75ec6a49@.posting.google.c om...
> Hello,
> My server is part of a W2K domain. What do you advice me as account to
> run my SQL*Server, service started with a domain user account or as
> local system ?
> I need advices from a security point of view.
> Thank's in advance|||Thank you for your opinion.

And I also agree to not use Local System, all the more since this
account as network access into the same W2K domain (that was not the
case under NT).

"GL" <GL@.noSpam.ReplyToNewsgroup.com> wrote in message news:<108ddd45gbs8k69@.news.supernews.com>...
> Depends on your requirements...
> First, I would personally never recommend running SQL in a production
> environment as Local System.
> If the SQL proccess will ever need to connect to file shares on other
> machines (like to backup data to remote location etc...) then you can either
> use a domain account, or use local accounts with matching usernames and
> passwords on the SQL server and any machine it may connect to.
> If your SQL proccess will never connect to File shares, or similar resources
> on the network, then you should run it with a Local User account on the box.
> But of course, this is just my opinion.
> GL
> "Kona" <kona_iron@.yahoo.fr> wrote in message
> news:a1de658a.0404191607.75ec6a49@.posting.google.c om...
> > Hello,
> > My server is part of a W2K domain. What do you advice me as account to
> > run my SQL*Server, service started with a domain user account or as
> > local system ?
> > I need advices from a security point of view.
> > Thank's in advance|||Depends on your requirements...

First, I would personally never recommend running SQL in a production
environment as Local System.

If the SQL proccess will ever need to connect to file shares on other
machines (like to backup data to remote location etc...) then you can either
use a domain account, or use local accounts with matching usernames and
passwords on the SQL server and any machine it may connect to.

If your SQL proccess will never connect to File shares, or similar resources
on the network, then you should run it with a Local User account on the box.

But of course, this is just my opinion.

GL

"Kona" <kona_iron@.yahoo.fr> wrote in message
news:a1de658a.0404191607.75ec6a49@.posting.google.c om...
> Hello,
> My server is part of a W2K domain. What do you advice me as account to
> run my SQL*Server, service started with a domain user account or as
> local system ?
> I need advices from a security point of view.
> Thank's in advance|||Thank you for your opinion.

And I also agree to not use Local System, all the more since this
account as network access into the same W2K domain (that was not the
case under NT).

"GL" <GL@.noSpam.ReplyToNewsgroup.com> wrote in message news:<108ddd45gbs8k69@.news.supernews.com>...
> Depends on your requirements...
> First, I would personally never recommend running SQL in a production
> environment as Local System.
> If the SQL proccess will ever need to connect to file shares on other
> machines (like to backup data to remote location etc...) then you can either
> use a domain account, or use local accounts with matching usernames and
> passwords on the SQL server and any machine it may connect to.
> If your SQL proccess will never connect to File shares, or similar resources
> on the network, then you should run it with a Local User account on the box.
> But of course, this is just my opinion.
> GL
> "Kona" <kona_iron@.yahoo.fr> wrote in message
> news:a1de658a.0404191607.75ec6a49@.posting.google.c om...
> > Hello,
> > My server is part of a W2K domain. What do you advice me as account to
> > run my SQL*Server, service started with a domain user account or as
> > local system ?
> > I need advices from a security point of view.
> > Thank's in advance

domain user belonging to multiple windows group

If I have a domain user DOMAIN\user1 who belongs to multiple window groups say DOMAIN\LookupConfigUsers and DOMAIN\AuditConfigUsers. In sqlserver, I would create two logins - DOMAIN\LookupConfigUsers and DOMAIN\AuditConfigUsers and matching users in the database. Then I grant LookupConfig role to the LookupConfigUsers user and AuditConfig role to the AuditConfigUsers user in the database. When DOMAIN\user1 logs in, will it have both roles? I try to set this up but it does not seem to work. The domain user only picks up one of the role. Am I on the right track? If not, what is the proper way to grant multiple roles to a user when it belongs to multiple groups and each group has different privileges in the database.

Based on the scenario you described, DOMAIN\user should be a member of both roles ( LookupConfig role & AuditConfig role). You can use the following script to take a look to the login and user token on the current connection:

SELECT name, type, usage FROM sys.login_token ORDER BY type, name

SELECT name, type, usage FROM sys.user_token ORDER BY type, name

go

In the login token you should be able to look at all the server and Windows groups that are part of the token, while on the user token view you should be able to see the database roles and Windows roles that are part of the context.

The usage column will tell you how each row is used, typically it should be “GRANT OR DENY”, which means that row is being used to evaluate for both granted and denied permissions, while a “DENY ONLY” value means that only denied permissions will be honored.

Please let us know the results of this query. If you see both roles, my guess would be that either LookupConfig or AuditConfgi role has an explicit denied permission that is affecting the permission check.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

|||

It works now. It's actually my fault. I had one group defined initially and later when I add the other group, I simply disconnect and reconnect from the Management Studio. It did not pick up the new group. Today, I tried closing the Management Studio and reopen it, and it picks up both groups and roles. Your sql statements above showed me exactly what I expected - domin\user belongs to both LookConfig and AuditConfig Role.

However, I don't understand why it also belongs to the public role?

Also, the login_token output names like -

NT AUTHORITY\Authenticated Users, NT AUTHORITY\INTERACTIVE, NT AUTHORITY\NTLM Authentication, domain\None, \Everyone, etc...

What are these groups?

I am new to sqlserver and windows authentication. Any help would be much appreciated.

|||

No problem, we are happy to help.The public role is a role that everyone in the system belongs to, think of the public as “Everyone”. If you grant any permission to public, everyone will get it. This behavior is automatic and cannot be changed.

Regarding the other Windows groups in the login token. To generate the SQL Server login token we take the token from the Windows client connection and get every group from it. You can double check it in Windows using the whoami tool (i.e. whoami /groups).

I hope this information helps. Let us know if you have any further question, we will be glad to help.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

Domain Question

Hi,
We are going to configure a 2-node active/passive SQL
server cluster using W2003 Server Enterprise.
A requirement is that both nodes be a member of the same
domain.
We want to make one of these nodes the Primary Domain
Controller. Obviously if you lose that node in the cluster
you will lose the PDC! Can we make the other node a backup
domain controller? So, we can pull the plug on the PDC and
the BDC will now act as domain controller (and SQL server
will failover too)? Will that work
So is it a bad idea in a 2-node cluster to also have the
PDC and BDC be the nodes in the cluster?
Thanks.
We should not configure our cluster nodes as domain controllers; instead, we should use dedicated domain controllers. If we do configure our nodes in any combination of a primary and backup domain controller, it
could have direct implications for any SQL Server environment, as noted in the following Microsoft Knowledge Base articles
298570 BUG: Virtual SQL Server 2000 Installations May Fail if Installed to Windows 2000 Domain Controllers
http://support.microsoft.com/?id=298570
281662 Windows 2000 and Windows Server 2003 Cluster Nodes As Domain Controllers
http://support.microsoft.com/?id=281662
In general, we should NOT install SQL Server 2000 on a domain controller.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Domain and windows authentication

Hi,
We have a application that uses windows authentication to connect to sql
server. We have a domain and simply just create a login in sql server for
each user in the domain.
We have setup this application in the company that doesn't have domain.
We're not going to change the source of the application to accept sql server
authentication.
Can we still use the windows authentication to allow the users to log in?
Suppose that each user logs in his computer as administrator of that
computer. Can we prefix these administrators with the name of their
computers to create login in sql server and still use windows
authentication?
Any help would be greatly appreciated.
Amin
Microsoft SQL Server support only Domain Authentification, no Machine
Account Authentification (except the local machine of the sql server),
because Workgroups are not trustable.
Hope this helps,
Jens Smeyer
"Amin Sobati" <amins@.morva.net> schrieb im Newsbeitrag
news:%23ahXq45gEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Hi,
> We have a application that uses windows authentication to connect to sql
> server. We have a domain and simply just create a login in sql server for
> each user in the domain.
> We have setup this application in the company that doesn't have domain.
> We're not going to change the source of the application to accept sql
server
> authentication.
> Can we still use the windows authentication to allow the users to log in?
> Suppose that each user logs in his computer as administrator of that
> computer. Can we prefix these administrators with the name of their
> computers to create login in sql server and still use windows
> authentication?
> Any help would be greatly appreciated.
> Amin
>
|||Jens,
Therefore in workgroups there's no other solution except using sql server
authentication?
"Jens Smeyer" <MrIgel[RejectSpam|RemoveBracket]@.gmx.de> wrote in message
news:OCvmQg7gEHA.2764@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Microsoft SQL Server support only Domain Authentification, no Machine
> Account Authentification (except the local machine of the sql server),
> because Workgroups are not trustable.
> Hope this helps,
> Jens Smeyer
>
> "Amin Sobati" <amins@.morva.net> schrieb im Newsbeitrag
> news:%23ahXq45gEHA.1764@.TK2MSFTNGP10.phx.gbl...
for[vbcol=seagreen]
> server
in?
>
|||You should be able to use NT authentication by doing the following:
1. Create a local account on the SQL Server machine that matches each
individual users local machine account. Make sure the password is the same
for both accounts.
2. Create a login within SQL Server for each of these logins.
3. NT authentication should now work.
This could be difficult to administer becaues each time a user changes his
local opassword the pasword has to be changed at the SQL Server machine as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Rand,
What if users log into their computer with administrator account?
Necessarily they must use different user names?
Amin
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:Qxq9sH9gEHA.3340@.cpmsftngxa06.phx.gbl...
> You should be able to use NT authentication by doing the following:
> 1. Create a local account on the SQL Server machine that matches each
> individual users local machine account. Make sure the password is the same
> for both accounts.
> 2. Create a login within SQL Server for each of these logins.
> 3. NT authentication should now work.
> This could be difficult to administer becaues each time a user changes his
> local opassword the pasword has to be changed at the SQL Server machine as
> well.
> Rand
>
> This posting is provided "as is" with no warranties and confers no rights.
>