Hello...
What we are trying to accomplish is to be able to replicate from Sql Server 2000 to some laptops running MSDE across the internet. These laptops are NOT part of our domain. I have set up a publication to allow for anonymous pull subscriptions for transa
ctional replication. Everything works fine now...except that for my test I had to setup/configure the laptop with a Hosts and LMHosts file so that it could resolve the server's name from its fully qualified name. This will be a pain for us to implement
and deploy....as we will have hundreds of client machines connecting to our server. The problem has to do with a sql server table that stores the name of the server publisher & distributor.
I noticed (via the sql server profiler tool) that when replication begins, there is some intial login/handshaking that occurs and one of the principal commands that gets executed is something like: exec sp_helpdistpublisher N'ServerName'. This stored pr
oc queries the MSDistPublisher table in the MSDB database. The stored proc returns a single row of data which includes our server's name...as it has been setup...it's machine name. This table does not include (obviously) a record that has the server's fu
lly qualified domain name (ServerName.Domain.Com).
My question is: is there a way to add an additional row of data and use the fully qualified domain name?
thanks for any help.
- DW
in your application, can't you hard code the publisher name with the FQDN
for the publisher/distributor?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"DW" <DW@.discussions.microsoft.com> wrote in message
news:62391DE0-137B-46EE-9024-9E679829FD84@.microsoft.com...
> Hello...
> What we are trying to accomplish is to be able to replicate from Sql
Server 2000 to some laptops running MSDE across the internet. These laptops
are NOT part of our domain. I have set up a publication to allow for
anonymous pull subscriptions for transactional replication. Everything
works fine now...except that for my test I had to setup/configure the laptop
with a Hosts and LMHosts file so that it could resolve the server's name
from its fully qualified name. This will be a pain for us to implement and
deploy....as we will have hundreds of client machines connecting to our
server. The problem has to do with a sql server table that stores the name
of the server publisher & distributor.
> I noticed (via the sql server profiler tool) that when replication begins,
there is some intial login/handshaking that occurs and one of the principal
commands that gets executed is something like: exec sp_helpdistpublisher
N'ServerName'. This stored proc queries the MSDistPublisher table in the
MSDB database. The stored proc returns a single row of data which includes
our server's name...as it has been setup...it's machine name. This table
does not include (obviously) a record that has the server's fully qualified
domain name (ServerName.Domain.Com).
> My question is: is there a way to add an additional row of data and use
the fully qualified domain name?
> thanks for any help.
> - DW
Showing posts with label msde. Show all posts
Showing posts with label msde. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
How to create image field?
Hello,
I would like to store some images in an msde table. When I go into the
enterprise manager design table mode and pick image as a field type, it
defaults to 16 bytes in size, and doesn't allow me to change the size. I
can't create a varbinary field greater than 8000 bytes either. The msde
instance is a recent install downloaded fresh from Microsoft, so it is the
current version (but for the life of me I can't figure out how to determine
the version #).
I've also tried using a shareware package called MSDE manager, but with the
same results.
How do I create an image field of 50K, for example?
thanks
Marc Pelletier
Hi,
It is not an issue, By default it will take bytes. Image data type will
allow you store a maximum of 2 GB. No need to change any thing
VARBINARY will allow a maximum of bytes.
Thanks
Hari
SQL Server MVP
"Marc Pelletier" <no.email@.please.com> wrote in message
news:Xns959A92CA0DCBAmpdd445@.216.168.3.44...
> Hello,
> I would like to store some images in an msde table. When I go into the
> enterprise manager design table mode and pick image as a field type, it
> defaults to 16 bytes in size, and doesn't allow me to change the size. I
> can't create a varbinary field greater than 8000 bytes either. The msde
> instance is a recent install downloaded fresh from Microsoft, so it is the
> current version (but for the life of me I can't figure out how to
> determine
> the version #).
> I've also tried using a shareware package called MSDE manager, but with
> the
> same results.
> How do I create an image field of 50K, for example?
> thanks
> Marc Pelletier
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in news:eFR6PmUxEHA.1264
@.TK2MSFTNGP12.phx.gbl:
> It is not an issue, By default it will take bytes. Image data type will
> allow you store a maximum of 2 GB. No need to change any thing
> VARBINARY will allow a maximum of bytes.
>
I don't mean to look a gift horse in the mouth, but you haven't told me
anything. Do you mean to say that even though it appears to be 16 bytes, I
can actually stuff whatever I want in there? That doesn't seem likely.
cheers
Marc Pelletier
|||> I don't mean to look a gift horse in the mouth, but you haven't told me
> anything. Do you mean to say that even though it appears to be 16 bytes, I
> can actually stuff whatever I want in there? That doesn't seem likely.
Stop looking at enterprise manager to "tell you anything." The 16 bytes
represents a pointer to the data, not the actual data. Hari was not lying
when he said that you can store ~2 GB of data in there...
|||Typically, all that is stored in the data row for image, text, or ntext
columns is a 16 byte pointer to where the actual data is stored. You can
store up to 2GB of data for each data value using these data types.
For more information about how the data for these data types are stored,
see:
http://msdn.microsoft.com/library/?u...asp?frame=true
http://msdn.microsoft.com/library/?u...asp?frame=true
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Content Architect
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
|||"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
news:#l6OeKbxEHA.2876@.TK2MSFTNGP12.phx.gbl:
> Stop looking at enterprise manager to "tell you anything." The 16
> bytes represents a pointer to the data, not the actual data. Hari was
> not lying when he said that you can store ~2 GB of data in there...
>
Ok, thanks, I didn't think he was lying ( and if I gave that impression,
sorry). That being the case, how come varbinary allows me to set the size
up to 8000, when it also has a limit of ~2G? How would I define my field
to store a large amount of data?
I'm guessing that under the hood they are essentially the same type,
since I could stream any binary data into an image field anyway, couldn't
I?
thanks
Marc Pelletier
|||> sorry). That being the case, how come varbinary allows me to set the size
> up to 8000, when it also has a limit of ~2G?
Who said varbinary has a limit of ~2 GB?
> How would I define my field
> to store a large amount of data?
Using the IMAGE datatype, not VARBINARY.
> I'm guessing that under the hood they are essentially the same type,
> since I could stream any binary data into an image field anyway, couldn't
> I?
I'm not going to presume to know exactly how the engine works with these
types. But I know that they are stored at least slightly differently,
similar to VARCHAR(8000) and TEXT (even though, deep down, they are both
just storing text).
|||"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
news:O0zalzcxEHA.2568@.TK2MSFTNGP10.phx.gbl:
> Who said varbinary has a limit of ~2 GB?
>
Well... I did. But I shouldn't have. If it isn't clear already, I'm new to
sql server. I generally vigorously avoid database programming, but can't
avoid it for my current project.
Thanks for the help, everyone. I think I'm away for now.
Marc
|||Hello,
I am new to databases. But i dont understand how one could store a picture
in a cell in a database? Or do you mean that there is a link to the picture
in the cell?
Thanks
WStoreyII
"Marc Pelletier" wrote:
> Hello,
> I would like to store some images in an msde table. When I go into the
> enterprise manager design table mode and pick image as a field type, it
> defaults to 16 bytes in size, and doesn't allow me to change the size. I
> can't create a varbinary field greater than 8000 bytes either. The msde
> instance is a recent install downloaded fresh from Microsoft, so it is the
> current version (but for the life of me I can't figure out how to determine
> the version #).
> I've also tried using a shareware package called MSDE manager, but with the
> same results.
> How do I create an image field of 50K, for example?
> thanks
> Marc Pelletier
>
|||=?Utf-8?B?V1N0b3JleUlJ?= <WStoreyII@.discussions.microsoft.com> wrote in
news:54836FEC-DDCB-4F80-85F0-13F580D4C292@.microsoft.com:
> I am new to databases. But i dont understand how one could store a
> picture in a cell in a database? Or do you mean that there is a link
> to the picture in the cell?
>
WStorey,
The image is stored as a binary stream directly in a blob (binary large
object, I think ) field of the database. It adds a substantial overhead to
the process, and I think that in many cases it is better to store the image
on disk and store a reference to it in the db, as you have suggested.
However it is what I am going to do. In my case the number ( and size) of
images will be fairly small and dynamic, maybe a couple of thousand, and
will be accessed a lot, so I expext the sql server cacheing to help with
the performance hit.
The how is explained quite clearly in
http://support.microsoft.com/default...en-us;309158#1
for the csharp case.
Hope this helps.
Marc Pelletier
I would like to store some images in an msde table. When I go into the
enterprise manager design table mode and pick image as a field type, it
defaults to 16 bytes in size, and doesn't allow me to change the size. I
can't create a varbinary field greater than 8000 bytes either. The msde
instance is a recent install downloaded fresh from Microsoft, so it is the
current version (but for the life of me I can't figure out how to determine
the version #).
I've also tried using a shareware package called MSDE manager, but with the
same results.
How do I create an image field of 50K, for example?
thanks
Marc Pelletier
Hi,
It is not an issue, By default it will take bytes. Image data type will
allow you store a maximum of 2 GB. No need to change any thing
VARBINARY will allow a maximum of bytes.
Thanks
Hari
SQL Server MVP
"Marc Pelletier" <no.email@.please.com> wrote in message
news:Xns959A92CA0DCBAmpdd445@.216.168.3.44...
> Hello,
> I would like to store some images in an msde table. When I go into the
> enterprise manager design table mode and pick image as a field type, it
> defaults to 16 bytes in size, and doesn't allow me to change the size. I
> can't create a varbinary field greater than 8000 bytes either. The msde
> instance is a recent install downloaded fresh from Microsoft, so it is the
> current version (but for the life of me I can't figure out how to
> determine
> the version #).
> I've also tried using a shareware package called MSDE manager, but with
> the
> same results.
> How do I create an image field of 50K, for example?
> thanks
> Marc Pelletier
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in news:eFR6PmUxEHA.1264
@.TK2MSFTNGP12.phx.gbl:
> It is not an issue, By default it will take bytes. Image data type will
> allow you store a maximum of 2 GB. No need to change any thing
> VARBINARY will allow a maximum of bytes.
>
I don't mean to look a gift horse in the mouth, but you haven't told me
anything. Do you mean to say that even though it appears to be 16 bytes, I
can actually stuff whatever I want in there? That doesn't seem likely.
cheers
Marc Pelletier
|||> I don't mean to look a gift horse in the mouth, but you haven't told me
> anything. Do you mean to say that even though it appears to be 16 bytes, I
> can actually stuff whatever I want in there? That doesn't seem likely.
Stop looking at enterprise manager to "tell you anything." The 16 bytes
represents a pointer to the data, not the actual data. Hari was not lying
when he said that you can store ~2 GB of data in there...
|||Typically, all that is stored in the data row for image, text, or ntext
columns is a 16 byte pointer to where the actual data is stored. You can
store up to 2GB of data for each data value using these data types.
For more information about how the data for these data types are stored,
see:
http://msdn.microsoft.com/library/?u...asp?frame=true
http://msdn.microsoft.com/library/?u...asp?frame=true
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Content Architect
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
|||"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
news:#l6OeKbxEHA.2876@.TK2MSFTNGP12.phx.gbl:
> Stop looking at enterprise manager to "tell you anything." The 16
> bytes represents a pointer to the data, not the actual data. Hari was
> not lying when he said that you can store ~2 GB of data in there...
>
Ok, thanks, I didn't think he was lying ( and if I gave that impression,
sorry). That being the case, how come varbinary allows me to set the size
up to 8000, when it also has a limit of ~2G? How would I define my field
to store a large amount of data?
I'm guessing that under the hood they are essentially the same type,
since I could stream any binary data into an image field anyway, couldn't
I?
thanks
Marc Pelletier
|||> sorry). That being the case, how come varbinary allows me to set the size
> up to 8000, when it also has a limit of ~2G?
Who said varbinary has a limit of ~2 GB?
> How would I define my field
> to store a large amount of data?
Using the IMAGE datatype, not VARBINARY.
> I'm guessing that under the hood they are essentially the same type,
> since I could stream any binary data into an image field anyway, couldn't
> I?
I'm not going to presume to know exactly how the engine works with these
types. But I know that they are stored at least slightly differently,
similar to VARCHAR(8000) and TEXT (even though, deep down, they are both
just storing text).
|||"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
news:O0zalzcxEHA.2568@.TK2MSFTNGP10.phx.gbl:
> Who said varbinary has a limit of ~2 GB?
>
Well... I did. But I shouldn't have. If it isn't clear already, I'm new to
sql server. I generally vigorously avoid database programming, but can't
avoid it for my current project.
Thanks for the help, everyone. I think I'm away for now.
Marc
|||Hello,
I am new to databases. But i dont understand how one could store a picture
in a cell in a database? Or do you mean that there is a link to the picture
in the cell?
Thanks
WStoreyII
"Marc Pelletier" wrote:
> Hello,
> I would like to store some images in an msde table. When I go into the
> enterprise manager design table mode and pick image as a field type, it
> defaults to 16 bytes in size, and doesn't allow me to change the size. I
> can't create a varbinary field greater than 8000 bytes either. The msde
> instance is a recent install downloaded fresh from Microsoft, so it is the
> current version (but for the life of me I can't figure out how to determine
> the version #).
> I've also tried using a shareware package called MSDE manager, but with the
> same results.
> How do I create an image field of 50K, for example?
> thanks
> Marc Pelletier
>
|||=?Utf-8?B?V1N0b3JleUlJ?= <WStoreyII@.discussions.microsoft.com> wrote in
news:54836FEC-DDCB-4F80-85F0-13F580D4C292@.microsoft.com:
> I am new to databases. But i dont understand how one could store a
> picture in a cell in a database? Or do you mean that there is a link
> to the picture in the cell?
>
WStorey,
The image is stored as a binary stream directly in a blob (binary large
object, I think ) field of the database. It adds a substantial overhead to
the process, and I think that in many cases it is better to store the image
on disk and store a reference to it in the db, as you have suggested.
However it is what I am going to do. In my case the number ( and size) of
images will be fairly small and dynamic, maybe a couple of thousand, and
will be accessed a lot, so I expext the sql server cacheing to help with
the performance hit.
The how is explained quite clearly in
http://support.microsoft.com/default...en-us;309158#1
for the csharp case.
Hope this helps.
Marc Pelletier
how to create filegroups
I was directed to create filegroups so that clients that install msde or sql
server would look the same Can anyone point me in the right direction on how
to
create the filegroups on msde.
I was thinking about just splitting up the indexes and tables at this
point. Is this what a sql server install would do so that they could take
advantage of Raid drive?
See Filegroups|Creating in Books Online. The basic syntax is:
ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
Then add files to the filegroup with:
ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
<filegroupname>
Jacco Schalkwijk
SQL Server MVP
"Keeper" <Keeper@.discussions.microsoft.com> wrote in message
news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>I was directed to create filegroups so that clients that install msde or
>sql
> server would look the same Can anyone point me in the right direction on
> how
> to
> create the filegroups on msde.
> I was thinking about just splitting up the indexes and tables at this
> point. Is this what a sql server install would do so that they could take
> advantage of Raid drive?
>
|||i appreciate the information
thanx
"Jacco Schalkwijk" wrote:
> See Filegroups|Creating in Books Online. The basic syntax is:
> ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
> Then add files to the filegroup with:
> ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
> <filegroupname>
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Keeper" <Keeper@.discussions.microsoft.com> wrote in message
> news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>
>
server would look the same Can anyone point me in the right direction on how
to
create the filegroups on msde.
I was thinking about just splitting up the indexes and tables at this
point. Is this what a sql server install would do so that they could take
advantage of Raid drive?
See Filegroups|Creating in Books Online. The basic syntax is:
ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
Then add files to the filegroup with:
ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
<filegroupname>
Jacco Schalkwijk
SQL Server MVP
"Keeper" <Keeper@.discussions.microsoft.com> wrote in message
news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>I was directed to create filegroups so that clients that install msde or
>sql
> server would look the same Can anyone point me in the right direction on
> how
> to
> create the filegroups on msde.
> I was thinking about just splitting up the indexes and tables at this
> point. Is this what a sql server install would do so that they could take
> advantage of Raid drive?
>
|||i appreciate the information
thanx
"Jacco Schalkwijk" wrote:
> See Filegroups|Creating in Books Online. The basic syntax is:
> ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
> Then add files to the filegroup with:
> ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
> <filegroupname>
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Keeper" <Keeper@.discussions.microsoft.com> wrote in message
> news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>
>
Friday, March 23, 2012
How to create Database and tables in MSDE
I have install the MSDE from Ofiice 2000 cd and my MSDE sql server is running fine that I can see from my tray bar with green arrow button. Now i want to create the database so can any body tell me how do i create database. Is there ne query analyser or enterprise manager by which I can create database. Also when i try to install starterkit it doen not allow me to install it. It ask me to select database from the dropdown list and when I select Localhost (only option available) and click on test connection it gives me error Unsuccessfull
I am new at MSDN so please help me.
1) You can rul SQL scripts directly against MSDE using the command line interface that comes with it.
2) If you have Access 2000, XP, or 2003, youcan create a new "Access Project" and connect to your MSDE instancegraphically.
3) For ~$50 U.S, you can purchase a copy ofSQL Server 2000 Developer Edition, and connect to MSDE via EnterpriseManager.
4) You can download and install a copy of SQLServer 2000 Evaluation Edition, and use Enterprise Manager fromthat. Attempt to decipher its licensing limitations at your ownrisk.
|||Could u tell me where to find command line b'se i tried to find it but coudn't. Sorry i m new at MSDE. pls tell me how can I connect through access project. Also I am unable to install Starter kit too.
Pls help me|||The command line tool is called osql.exe. Here's an article that'll help you use it: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003
For connecting though an Access Project, either follow the wizard, or look it up in Access help.
|||Thank you very much for your answer. I was able to find out the osql.exe utility.
I am having one problem when I try to execute the command osql -e it ask me password and when i type 'sa' as password it gives me error that the username is not associated with trusted sql server. I think when I installed the MSDE I did not give it any strong user name and password so I wil try again by giving strong [password t the time of installing it.
Once again thanx very much for your time.sql
how to create an stored procedure to an existan database?
i already hava an database in the MSDE database server, but now i want to add some stored procedures to that specifi database in the MSDE database server, how can i do that?You can use Enterprise Manager from SQL Server, and if you have the correct edition, you can use Visual Studio.NET.|||is there any other way?? like can i use comand prompt to create stored procedures?i want that way, and I have MSDE.|||I did reply to yourother post, and now that I see what you want to do, I also recommend this link:Administering SQL Server Using osql. There are further links at the bottom which should help you with what you are trying to do.
Terri|||thanks very much
that helps me a lot.sql
Monday, March 12, 2012
How to create a new user.
Hi!
I have downloaded the MSDE from the Microsoft site.
The installation of Forums Stater Kit unable to add ASPNET account in MSDE users list.
Can anyone tell me how i should add this user by myself in to MSDE users.
i don't have any enterprise manager etc. thing. Just MSDE.
and also what will be the password for this account [ASPNET]http://www.1000files.com/Software_Development/Databases_and_Networks/web_based_msde_admin_tool_-_Shusheng_SQL_Tool_3887_Review.html is a link to a free web based admin tool. ASPNET is automagically created when you installed ASP.NET and the .net framework. You won't know the password. HTH
Friday, March 9, 2012
How to create a database on MS SQL Server Desktop Engine
Dear friends,
Can anybody give me some piece of information about creating a database on SQL Server Desktop Engine.
I have installed MSDE 2000 (Rel A) on my system running Win 2000 Prof. The SQL Server icon is now visible on my taskpar with green arrow showing 'Running - \\ALI-LAPTOP' But I want to use it to accomodate my database currently in Access. I have tried to use Upsizing Wizard to create new database on it but it is giving this error (Login failed for user 'sa' (with password 'sa'). Not associated with a trusted SQL Server connection.)
I was also not able to connect it with ODBC.
Can you please help me even if seems to be setup problem. Because, the MSDE setup completed successfully with a good system restart.
Regards,
Zulfiqar AliBased on your description you are not providing the correct password for the SA account, or you are not using Mixed Mode authentication. You need to know which Authentication method you enabled when you installed MSDE to know how to log in.
Let’s assume you didn’t specify anything, then you are using Windows Authentication and the SA account isn’t enabled. In that case, the Upsize Wizard in Access will only work if you choose the option to use Windows Authentication when choosing your database. If you want to create a database without using the Upsize Wizard, you can do that using oSQL to run a CREATE DATABASE statement.
More information about oSQL: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp
Help on CREATE DATABASE statement: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp?frame=true
If you are using Mixed Mode authentication you should be able to log in using an appropriate User/Password combination. Make sure you are using the right password for your SA account, you would have had to set the password when you installed MSDE.
Hope this helps,
Mike
Wednesday, March 7, 2012
How to crearte database in MSDE
Ihave installed the MSDE from Office 2002 CD and MSDE is running. I can see the SQL Server Icon in tray with green arrow. CAn ne body help me how to create database in the MSDE. I am new to this. Is there any query manager or entrprise tool by which I can create database and table in it. Also I am not able ro install the Starter Kit .
Please help me in this.Answered here:http://forums.asp.net/1062587/ShowPost.aspx#1062587
Please help me in this.Answered here:http://forums.asp.net/1062587/ShowPost.aspx#1062587
Sunday, February 19, 2012
how to copy database?
i have an database created with MSDE using the windows authentication,and now i want to send this database to someone, can i just backup thisdatabase and send it,
can other people access my database with windows authenticaiton in his computer ? or i need to do some extra stuff?
I havent used MSDE but normally you can copy the mdf and ldf files and paste them in the Data folder of the server you want to move it onto and do an "Attach" database. right click on databases and select "Attach database" and follow the wizard.|||
but i have stored procedures within in the database, and when i detachthe database , will they not be ask some password stuff?? becausei this database used window authentication.
can i somehow get rid of this windows authentication to use the normal password version??
can other people access my database with windows authenticaiton in his computer ? or i need to do some extra stuff?
I havent used MSDE but normally you can copy the mdf and ldf files and paste them in the Data folder of the server you want to move it onto and do an "Attach" database. right click on databases and select "Attach database" and follow the wizard.|||
Theoretically, If you're using Windows Authentication - anyone in the domain would be able to access the database, once they're logged into the domain...(with the right tools, of course)
You can back it up or you can detach it and send the two files (.mdf and .ldf) files to the other person - they can then attach the files to their own server.
|||unfortunately the people i want to send is not in the domainbut i have stored procedures within in the database, and when i detachthe database , will they not be ask some password stuff?? becausei this database used window authentication.
can i somehow get rid of this windows authentication to use the normal password version??
Subscribe to:
Comments (Atom)