New to SQL Server

I am new to sql server, mostly work with an other product build by a company
in california. We can call it "company O"
We had a application written for our company. The version of SQL Server is
2000. They created all the objects owned by dbo. When I asked why, I was
told this is what Microsoft recommends. My question is why should the
objects be owned by dbo and not use the a model like
schema/username.objectname
Can some one explain why use the dbo as the owner of the objects in a
database vrs have a schema and then grant permissions on the objects in the
schema?In SQL Server 2000, schemas don't work that way. Having everything owned by
dbo makes it much easier to manage. SQL Server 2005 properly implements
schemas such that what you're talking about does make sense.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"jbwest77" <jbwest77@.discussions.microsoft.com> wrote in message
news:1C71EE4D-A6F0-42BE-A48E-693830152596@.microsoft.com...
>I am new to sql server, mostly work with an other product build by a
>company
> in california. We can call it "company O"
> We had a application written for our company. The version of SQL Server
> is
> 2000. They created all the objects owned by dbo. When I asked why, I was
> told this is what Microsoft recommends. My question is why should the
> objects be owned by dbo and not use the a model like
> schema/username.objectname
> Can some one explain why use the dbo as the owner of the objects in a
> database vrs have a schema and then grant permissions on the objects in
> the
> schema?|||On Mon, 21 Nov 2005 15:48:01 -0800, "jbwest77"
<jbwest77@.discussions.microsoft.com> wrote:
>I am new to sql server, mostly work with an other product build by a company
>in california. We can call it "company O"
>We had a application written for our company. The version of SQL Server is
>2000. They created all the objects owned by dbo. When I asked why, I was
>told this is what Microsoft recommends. My question is why should the
>objects be owned by dbo and not use the a model like
>schema/username.objectname
>Can some one explain why use the dbo as the owner of the objects in a
>database vrs have a schema and then grant permissions on the objects in the
>schema?
It's just always been that way, and various tools and defaults are
very awkward if you try to use ownership other than dbo.
If things are finally better in Yukon, then we'll just have to break
old habits!
So, I'd say that at least on this issue, so far I wouldn't hold it
against your developers.
J.|||In SQL Server 2000 you can implement the schema/username.objectname that you
mentioned, more exactly the username. You can create a user, like finance,
and give ownership of the objects to that user. We have several applications
like that and we do not have any problem.
If you want to implement schemas Oracle-style then we have SQL Server 2005.
Ben Nevarez
"jbwest77" <jbwest77@.discussions.microsoft.com> wrote in message
news:1C71EE4D-A6F0-42BE-A48E-693830152596@.microsoft.com...
>I am new to sql server, mostly work with an other product build by a
>company
> in california. We can call it "company O"
> We had a application written for our company. The version of SQL Server
> is
> 2000. They created all the objects owned by dbo. When I asked why, I was
> told this is what Microsoft recommends. My question is why should the
> objects be owned by dbo and not use the a model like
> schema/username.objectname
> Can some one explain why use the dbo as the owner of the objects in a
> database vrs have a schema and then grant permissions on the objects in
> the
> schema?|||Thanks for the input.
"Ben Nevarez" wrote:
> In SQL Server 2000 you can implement the schema/username.objectname that you
> mentioned, more exactly the username. You can create a user, like finance,
> and give ownership of the objects to that user. We have several applications
> like that and we do not have any problem.
> If you want to implement schemas Oracle-style then we have SQL Server 2005.
> Ben Nevarez
>
> "jbwest77" <jbwest77@.discussions.microsoft.com> wrote in message
> news:1C71EE4D-A6F0-42BE-A48E-693830152596@.microsoft.com...
> >I am new to sql server, mostly work with an other product build by a
> >company
> > in california. We can call it "company O"
> >
> > We had a application written for our company. The version of SQL Server
> > is
> > 2000. They created all the objects owned by dbo. When I asked why, I was
> > told this is what Microsoft recommends. My question is why should the
> > objects be owned by dbo and not use the a model like
> > schema/username.objectname
> > Can some one explain why use the dbo as the owner of the objects in a
> > database vrs have a schema and then grant permissions on the objects in
> > the
> > schema?
>
>

New to SQL server

Hi I am new to SQL Server and have a few general
questions.
1. Can anyone suggest a good book to learn how ti use SQL
Server... I am proficient with relational databases and
SQL (Not transact)
2. I would like to create a database using SQL server as
the backend and Access as the front end. If I house all
of my Queries in the Access front end and simply join the
tables to my SQL Server tables will I still be able to
take adavantage of the improvements in processing speed
and size of the SQL Server database or will I need to
change all of my Access queries to SQL views to be able to
do this?
Thanks for your help,
ChadTo get a good understanding of all aspects of SQL Server, try "Teach
yourself Microsoft SQL Server 2000 in 21 days".
For a deeper understanding of SQL Server architecture, go for "Inside
Microsoft SQL Server 2000":
http://vyaskn.tripod.com/inside_microsoft_sql_server_2000.htm
Links to these books and others are available at:
http://vyaskn.tripod.com/sqlbooks.htm
Regarding your other question, if your data is stored in SQL Server, and
accessed via queries from Access, you should be able to take advantage of
SQL Servers speed and robustness.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Chad" <ChadLucy@.msn.com> wrote in message
news:021501c38dca$91af4980$a401280a@.phx.gbl...
Hi I am new to SQL Server and have a few general
questions.
1. Can anyone suggest a good book to learn how ti use SQL
Server... I am proficient with relational databases and
SQL (Not transact)
2. I would like to create a database using SQL server as
the backend and Access as the front end. If I house all
of my Queries in the Access front end and simply join the
tables to my SQL Server tables will I still be able to
take adavantage of the improvements in processing speed
and size of the SQL Server database or will I need to
change all of my Access queries to SQL views to be able to
do this?
Thanks for your help,
Chad|||To get the best throughput from MSAccess you need to set up the MSAccess
project correctly as a SQL Server project. If you use the older project
style and "attached" tables, JET is used behind the scenes and performance
will be much worse. (I did MSAccess work a long time ago, and when they
introduced SQL projects it was a very new concept. Perhaps my advice today
is already common knowedge.) Anyway, the new style projects pass SQL
commands directly to SQL Server, and you can access database views as well
as base tables. I believe there is even a way to "wire up" the MSAccess
forms so that insert/update/delete commands can call stored procedures on
the server; a huge feature.
James|||Hello,
I have found two books to be extremely helpful -
particularly with Transact Sql:
-SQL Server 2k Stored Procedure Programming (Sunderic &
Woodhead)
-Adv T-SQL for SQL Server 2k (Ben-Gan and Moreau)
>--Original Message--
>Hi I am new to SQL Server and have a few general
>questions.
>1. Can anyone suggest a good book to learn how ti use
SQL
>Server... I am proficient with relational databases and
>SQL (Not transact)
>2. I would like to create a database using SQL server as
>the backend and Access as the front end. If I house all
>of my Queries in the Access front end and simply join the
>tables to my SQL Server tables will I still be able to
>take adavantage of the improvements in processing speed
>and size of the SQL Server database or will I need to
>change all of my Access queries to SQL views to be able
to
>do this?
>Thanks for your help,
>Chad
>.
>sql

new to sql please help

i use access 2000 as my front end. i had a form named main with a couple of unbound fields on it . i used to put in last name and first name and then in a query i would put "like [forms]![main]![text0] & "*"
and also "like [forms]![main]![text2] & "*"

the lookup patient button would open my patient form based on the query results of what i typed in on the main form . ex: i type in riley it would give me my patient form with all the riley's in it.

how do i get my access form to open from information i am looking for in a query now that my whole database is back on a sql server.

by the way i upsized to a adp file no longer using mdb. please if possible explain in detail how to do this as i am having trouble with the syntax of sql. i understand i cant use "*" as a wildcard now but % instead.

thanks in advance.Hoe are you connecting to SQL Sever?

You shouldn't have to change your code...did you create linked tables?|||im assuming they not linked tables since it is now a access project i dont see the little globe when i used to use link tables.

i think everything is useing passthorugh queries now all my tables are on the sql server. just the forms and macros are on the frontend now.

my code i had to change was something like

dim db as dao.database
dim rs as dao.recordset

i had to change that to
dim conn as adodb.connection
dim rs as new adodb.recordset

and quite a few other things

if i left them linked the queries should have stayed working but im trying to get away from passing things through the jet engine and using the full power of sql .|||this was my old code to make a chartnumber based on the first and last name fields. this is the one that didnt work .

Public Function chartlookup()
Dim db As DAO.Database <--believe to be the problem
Dim rs As DAO.Recordset <-- belive to be the problem
Dim SQL As String
Dim NewNum As Integer
Dim NeWChartNum As String

SQL = "Select max(Cint(Right([chartnumber],6))) As RecNum From tblpatientinfo WHERE UCase(Left([chartnumber],5)) = '" & UCase(Left([Forms]![fpatient]![lname], 3)) & UCase(Left([Forms]![fpatient]![fname], 2)) & "'"

Set db = CurrentDb() <-- -problem
Set rs = db.OpenRecordset(SQL) <--problem

If IsNull([Forms]![fpatient]![chartnumber]) = False Then GoTo 400

If rs.EOF = False Then
If IsNull(rs!RecNum) = False Then
NewNum = rs!RecNum + 1
Else
NewNum = 1
End If
End If
'If NewNum = 1 Then

[Forms]![fpatient]![chartnumber] = UCase(Left([Forms]![fpatient]![lname], 3)) & UCase(Left([Forms]![fpatient]![fname], 2)) & Format(NewNum, "000000")
'End If|||Well this is a TOTAL guess...

If you're doing passthrus, you'll need SQL Server syntax..

(Why not just call stored procedures if you're making such a radical change?)

anyway...

SQL = "SELECT (MAX(CONVERT(int,(RIGHT(chartnumber))))
FROM tblpatientinfo
WHERE UPPER(LEFT(chartnumber,5)) = " _
& "'" UCase(Left([Forms]![fpatient]![lname], 3)) & UCase(Left([Forms]![fpatient]![fname], 2)) & "'"

my front end skills have gotten rusty...

You might want to also look to post here:

http://www.sqlteam.com/forums/forum.asp?FORUM_ID=3|||i did get that code to work but my main real problem is how do i get user sitting at my main form where he has to enter a patients lst name and first then when he hits the lookup patient button it opens my patient record with only the patient he typed in from the previous form . this was easy on access just added the expression into the query . but sql doesnt seem to support forms based queries. so what i really need is what does sql use instead of forms based queries to prompt a user for what they want to fill a record with.

if i use select lname from tblpatientinfo where lname="riley"

my form will only give me patients with last name riley

but how do i get it to ask what name we are looking for i guess would be the real question here. do i make a stored procedure to prompt for the information and base the form on the stored procedure or does my from on open have to request what im looking for. i may not be useing the correct wording so please be patient but sql is a whole new world to me.
i tried useing a filter on my form but if i put the stored procedure in the filter it doesnt recognize the stored procedure name only access query names it seems.

New to SQL but want's to learn!

Hi,

I was wandering if anyone could please recommend a good book to learn the basics of SQL 2000? I have made connections etc to a sql db through Visual Studio but would really like to read up on the subject and get a complete grounding on the subject. And also prepare me for the exam 70-229.

Many thanks,
James

Hi

If you need to learn the exam for SQL, you are best buying the Microsoft suite of books for that exam but I can tell you this, it is not easy AT ALL.

To learn SQL, its best looked at examples, reading books again and trial and error.

C-sharp corner website is a good place, but also posting here is a good idea too and I am sure many people will help you out.

There is alot of ground to cover, so start with the basics and move on upwards.

New to SQL and Web development

I have been in systems for many years on the admin side, and have had experience working with developers, however I am attempting to start the learning process for creating a data store with a web based UI. I have an understanding of the theories of what
is possible, but I don't know where to start. I have experience with HTML coding and static pages, but nothing that interfaces with a back end.
What are your suggestions of where to start.
This is a great site with lots of good answers to many questions:
http://www.aspfaq.com/
You will find good examples and information out on =
http://www.asp101.com/
--=20
Keith
"Otts73" <sh_tmail@.charter.net> wrote in message =
news:EFF6B423-F1FA-41D1-9139-3929979CCB3F@.microsoft.com...
> I have been in systems for many years on the admin side, and have had =
experience working with developers, however I am attempting to start the =
learning process for creating a data store with a web based UI. I have =
an understanding of the theories of what is possible, but I don't know =
where to start. I have experience with HTML coding and static pages, =
but nothing that interfaces with a back end.
>=20
> What are your suggestions of where to start.
|||As well as Keith's references, you might like to look at
http://www.w3schools.com/ado/default.asp
Regards,
Paul Ibison

New to SQL and Web development

I have been in systems for many years on the admin side, and have had experi
ence working with developers, however I am attempting to start the learning
process for creating a data store with a web based UI. I have an understand
ing of the theories of what
is possible, but I don't know where to start. I have experience with HTML c
oding and static pages, but nothing that interfaces with a back end.
What are your suggestions of where to start.This is a great site with lots of good answers to many questions:
http://www.aspfaq.com/
You will find good examples and information out on =
http://www.asp101.com/
--=20
Keith
"Otts73" <sh_tmail@.charter.net> wrote in message =
news:EFF6B423-F1FA-41D1-9139-3929979CCB3F@.microsoft.com...
> I have been in systems for many years on the admin side, and have had =
experience working with developers, however I am attempting to start the =
learning process for creating a data store with a web based UI. I have =
an understanding of the theories of what is possible, but I don't know =
where to start. I have experience with HTML coding and static pages, =
but nothing that interfaces with a back end.
>=20
> What are your suggestions of where to start.|||As well as Keith's references, you might like to look at
http://www.w3schools.com/ado/default.asp
Regards,
Paul Ibison

New to SQL and Web development

I have been in systems for many years on the admin side, and have had experience working with developers, however I am attempting to start the learning process for creating a data store with a web based UI. I have an understanding of the theories of what is possible, but I don't know where to start. I have experience with HTML coding and static pages, but nothing that interfaces with a back end
What are your suggestions of where to start.This is a great site with lots of good answers to many questions:
http://www.aspfaq.com/
You will find good examples and information out on =http://www.asp101.com/
-- Keith
"Otts73" <sh_tmail@.charter.net> wrote in message =news:EFF6B423-F1FA-41D1-9139-3929979CCB3F@.microsoft.com...
> I have been in systems for many years on the admin side, and have had =experience working with developers, however I am attempting to start the =learning process for creating a data store with a web based UI. I have =an understanding of the theories of what is possible, but I don't know =where to start. I have experience with HTML coding and static pages, =but nothing that interfaces with a back end.
> > What are your suggestions of where to start.|||As well as Keith's references, you might like to look at
http://www.w3schools.com/ado/default.asp
Regards,
Paul Ibisonsql

new to sql and need some help. connectivity problems.

hi guy
i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is when i go to install sms or mom on the other boxes it doesnt see the sql server. however if i start the mom setup process on the sql box it sees the sql sever
i have installed the client tools on both the sms and mom boxes and configured them point to the sql server over tcp/ip and the named pipe but to no avail. i also added a data source to the odbc console thinking that may help but no it didnt
what i've done so fa
installed sql with integrated windows authenticatio
added it to a
got the Microsoft SQL Server 2000 Books Online from the ms sit
gone and purchased the ms sql server 2000 administration guid
started to read both books and am now scared of sql server 200
are there some connectivity tools that would help in troubleshooting this or am i barking up the wrong tree
i have used sms and mom extensively before but this is my first attempt at sql
cheer
dDid you install SQL Server or MSDE? Basically, on the client, you use SQL Server's "Client Network Utility"
and on the server, you use "Server Network Utility" to configure the connectivity. If you have MSDE, it
doesn't have network access turned on by default, and you won't have an icon for SNU, but it is there and the
name of the exe file is: svrnetcn.exe.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1AFB725A-1AF3-47BC-808B-198916327FCA@.microsoft.com...
> hi guys
> i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is
when i go to install sms or mom on the other boxes it doesnt see the sql server. however if i start the mom
setup process on the sql box it sees the sql sever.
> i have installed the client tools on both the sms and mom boxes and configured them point to the sql server
over tcp/ip and the named pipe but to no avail. i also added a data source to the odbc console thinking that
may help but no it didnt.
> what i've done so far
> installed sql with integrated windows authentication
> added it to ad
> got the Microsoft SQL Server 2000 Books Online from the ms site
> gone and purchased the ms sql server 2000 administration guide
> started to read both books and am now scared of sql server 2000
> are there some connectivity tools that would help in troubleshooting this or am i barking up the wrong tree?
> i have used sms and mom extensively before but this is my first attempt at sql.
> cheers
> d

new to sql and need some help. connectivity problems.

hi guys
i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is when i go to install sms or mom on the other boxes it doesnt see the sql server. however if i start the mom setup process on the sql box it sees the
sql sever.
i have installed the client tools on both the sms and mom boxes and configured them point to the sql server over tcp/ip and the named pipe but to no avail. i also added a data source to the odbc console thinking that may help but no it didnt.
what i've done so far
installed sql with integrated windows authentication
added it to ad
got the Microsoft SQL Server 2000 Books Online from the ms site
gone and purchased the ms sql server 2000 administration guide
started to read both books and am now scared of sql server 2000
are there some connectivity tools that would help in troubleshooting this or am i barking up the wrong tree?
i have used sms and mom extensively before but this is my first attempt at sql.
cheers
d
Did you install SQL Server or MSDE? Basically, on the client, you use SQL Server's "Client Network Utility"
and on the server, you use "Server Network Utility" to configure the connectivity. If you have MSDE, it
doesn't have network access turned on by default, and you won't have an icon for SNU, but it is there and the
name of the exe file is: svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1AFB725A-1AF3-47BC-808B-198916327FCA@.microsoft.com...
> hi guys
> i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is
when i go to install sms or mom on the other boxes it doesnt see the sql server. however if i start the mom
setup process on the sql box it sees the sql sever.
> i have installed the client tools on both the sms and mom boxes and configured them point to the sql server
over tcp/ip and the named pipe but to no avail. i also added a data source to the odbc console thinking that
may help but no it didnt.
> what i've done so far
> installed sql with integrated windows authentication
> added it to ad
> got the Microsoft SQL Server 2000 Books Online from the ms site
> gone and purchased the ms sql server 2000 administration guide
> started to read both books and am now scared of sql server 2000
> are there some connectivity tools that would help in troubleshooting this or am i barking up the wrong tree?
> i have used sms and mom extensively before but this is my first attempt at sql.
> cheers
> d

new to sql and need some help. connectivity problems.

hi guys
i've installed sql on a dedicated box for the purpose of using it for mom an
d sms but the only problem is when i go to install sms or mom on the other b
oxes it doesnt see the sql server. however if i start the mom setup process
on the sql box it sees the
sql sever.
i have installed the client tools on both the sms and mom boxes and configur
ed them point to the sql server over tcp/ip and the named pipe but to no ava
il. i also added a data source to the odbc console thinking that may help bu
t no it didnt.
what i've done so far
installed sql with integrated windows authentication
added it to ad
got the Microsoft SQL Server 2000 Books Online from the ms site
gone and purchased the ms sql server 2000 administration guide
started to read both books and am now scared of sql server 2000
are there some connectivity tools that would help in troubleshooting this or
am i barking up the wrong tree?
i have used sms and mom extensively before but this is my first attempt at s
ql.
cheers
dDid you install SQL Server or MSDE? Basically, on the client, you use SQL Se
rver's "Client Network Utility"
and on the server, you use "Server Network Utility" to configure the connect
ivity. If you have MSDE, it
doesn't have network access turned on by default, and you won't have an icon
for SNU, but it is there and the
name of the exe file is: svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1AFB725A-1AF3-47BC-808B-198916327FCA@.microsoft.com...
> hi guys
> i've installed sql on a dedicated box for the purpose of using it for mom and sms
but the only problem is
when i go to install sms or mom on the other boxes it doesnt see the sql ser
ver. however if i start the mom
setup process on the sql box it sees the sql sever.
> i have installed the client tools on both the sms and mom boxes and configured the
m point to the sql server
over tcp/ip and the named pipe but to no avail. i also added a data source t
o the odbc console thinking that
may help but no it didnt.
> what i've done so far
> installed sql with integrated windows authentication
> added it to ad
> got the Microsoft SQL Server 2000 Books Online from the ms site
> gone and purchased the ms sql server 2000 administration guide
> started to read both books and am now scared of sql server 2000
> are there some connectivity tools that would help in troubleshooting this
or am i barking up the wrong tree?
> i have used sms and mom extensively before but this is my first attempt at
sql.
> cheers
> d

New to SQL and need help

I am running a program that was created in VB that takes data from a
scanned file and inserts it into our database. We have the column
student id as the primary key and it is decremented every time it goes
through the program so they are each unique and never overlap. The
program has been working fine but recently when I run it I get a
primary key violation. I thought that the identity might have gotten
out of sync and tried CheckIdent but still no luck. I came to find
out that the primary key does not have an identity and so I am not
sure why it will not let me insert the data.It is just that the value you are trying to insert already exists.

--
Posted via http://dbforums.com|||I've looked at the table that I am trying to insert into and did a query
for numbers that overlapped and it returned nothing.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Hightower130 (bowens@.webebi.com) writes:
> I am running a program that was created in VB that takes data from a
> scanned file and inserts it into our database. We have the column
> student id as the primary key and it is decremented every time it goes
> through the program so they are each unique and never overlap. The
> program has been working fine but recently when I run it I get a
> primary key violation. I thought that the identity might have gotten
> out of sync and tried CheckIdent but still no luck. I came to find
> out that the primary key does not have an identity and so I am not
> sure why it will not let me insert the data.

And since I don't see your database, your input file, your VB code etc,
neither can I tell what went wrong.

It is possible that if you posted some code that it would help, but
since you have the existing data, and the problem appears to be
reproducible - how about debugging it?

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

New to SQL 2005, need a little help

I come from a Sys Admin background so excuse my questions if their
simple in nature.
Anyways we purchase an e-mail system at our company that uses SQL
server as it's database. In the documentation, it states I need to
create a SQL account and give it a specific username and password. I
can create the account, but it doesn't ask for a password. Do SQL
account's usually have passwords, or could they be referring to the SA
password I used when installing SQL? Also, when creating a SQL account,
it asks for a user name and login name. I can specify the user name,
but I can only select from a small list login name's to use. If someone
can clarify what the login name is exactly I'd appreciate it (i believe
it's the windows security account which sql uses to gain access to the
server but i dont know).
Thanksbdhenderson@.gmail.com wrote:
> I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks
>
You are creating Windows Authentication logins, not SQL logins. SQL
Server supports both.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It might be useful for you to know more about SQL Server Security.
From SQL Server Management Studio, click on [Help], then [Contents], then
[SQL Server Books on Line], and find the topic [Security Considerations for
SQL Server]
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
<bdhenderson@.gmail.com> wrote in message
news:1152796948.762797.20070@.h48g2000cwc.googlegroups.com...
>I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks
>|||I think you are in the wrong section of the GUI. From what you
described in the GUI you connected to a server, and opened databases,
then opened a database, then opened security. You then right clicked
and selected new user.
What you actually need to do it after connecting to the server, leave
the databases folder closed. You should see a security folder. Open
that up, this will allow you to create a login and assign it a
password.
SQL Server has logins and users. Logins have passwords and allow you
to log into the database. Users are mapped to a login and give you the
right to see inside a single database on the server.
Denny
bdhenderson@.gmail.com wrote:
> I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thankssql

New to SQL 2005, need a little help

I come from a Sys Admin background so excuse my questions if their
simple in nature.
Anyways we purchase an e-mail system at our company that uses SQL
server as it's database. In the documentation, it states I need to
create a SQL account and give it a specific username and password. I
can create the account, but it doesn't ask for a password. Do SQL
account's usually have passwords, or could they be referring to the SA
password I used when installing SQL? Also, when creating a SQL account,
it asks for a user name and login name. I can specify the user name,
but I can only select from a small list login name's to use. If someone
can clarify what the login name is exactly I'd appreciate it (i believe
it's the windows security account which sql uses to gain access to the
server but i dont know).
Thanksbdhenderson@.gmail.com wrote:
> I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks
>
You are creating Windows Authentication logins, not SQL logins. SQL
Server supports both.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It might be useful for you to know more about SQL Server Security.
From SQL Server Management Studio, click on [Help], then [Contents],
then
[SQL Server Books on Line], and find the topic [Security Considerati
ons for
SQL Server]
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
<bdhenderson@.gmail.com> wrote in message
news:1152796948.762797.20070@.h48g2000cwc.googlegroups.com...
>I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks
>|||I think you are in the wrong section of the GUI. From what you
described in the GUI you connected to a server, and opened databases,
then opened a database, then opened security. You then right clicked
and selected new user.
What you actually need to do it after connecting to the server, leave
the databases folder closed. You should see a security folder. Open
that up, this will allow you to create a login and assign it a
password.
SQL Server has logins and users. Logins have passwords and allow you
to log into the database. Users are mapped to a login and give you the
right to see inside a single database on the server.
Denny
bdhenderson@.gmail.com wrote:
> I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks

New to SQL 2005 Express

I haven't used this software except locally on my laptop. If you have built a databased web app using this, how do you deploy the db? Does it have to be installed and/or supported on your webhosting service? If so, it seems to be of limited use, if not, very helpful.

Thanks for the help

To deploy the application, the destination will need to have SQL Server Express installed as well. You can read a detailed article about that here:

http://msdn2.microsoft.com/en-us/library/ms165639.aspx

Buck Woody

|||

That's what I was afraid of....doesn't look as this will be the answer. Back to mysql or MS SQl 2000.

Thanks for the reply!!

TLCoop

|||No problem - but MySQL or MS SQL 2000 will have the same issue, won't it?|||

There might be some confusion here. SQL Express is SQL Server 2005. Your hoster will need to support SQL Server 2005, but they don't have to have SQL Express installed. It's the exact same database file because they are the exact same products, just with different feature sets.

If you're hosting company requires that you upload your database using scripts, we are working on a tool to help do that. You can find a CTP of the tool on CodePlex.

Mike

|||

Thanks Mike,

My host doesn't offer mssql 2005 yet. They do have mssql 2000, and maybe(hopefully)some of sqlexpress2005 is backwards compatible. I can always generate scripts and run a query for db population on mssql 2000. I'll take a look at CodePlex.

I appreciate the help!

Terry

|||

Thanks Buck for the reply. My Host doesn't offer MSSQL 2005 nor SQLExpress 2005 support yet. They offer both MySQl and MS SQL 2000 right now, so I'll try and 'script' a db from express 2005. I appreciate the help.

Terry

new to SQL 2005

Hello,

I just installed SQL 2005 on my laptop,,,, I know this is not an email question but maybe you can guide me to where i can find the answers.....

I want to test it out and configure it with cognos and informatica.....

Is it possible for me to create sample servers and configure it for a test

I did instal web Server (Abyss), not sure if this helps......

How do i set up a test server on my computer

And is all possible to do it on one computer?

thank-you in advance

Is this what you're looking for?

https://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

Best regards

- Jens

|||

Thank-you! but i already installed them,

Im looking for is how to configure it so it will work with them?

thank-you !

|||

Hi,

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

thank-you

|||

Have a look at this url:

http://msdn2.microsoft.com/en-us/library/ms143708.aspx

Best regards

- Jens

new to SQL 2005

Hello,

I just installed SQL 2005 on my laptop,,,, I know this is not an email question but maybe you can guide me to where i can find the answers.....

I want to test it out and configure it with cognos and informatica.....

Is it possible for me to create sample servers and configure it for a test

I did instal web Server (Abyss), not sure if this helps......

How do i set up a test server on my computer

And is all possible to do it on one computer?

thank-you in advance

Is this what you're looking for?

https://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

Best regards

- Jens

|||

Thank-you! but i already installed them,

Im looking for is how to configure it so it will work with them?

thank-you !

|||

Hi,

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

thank-you

|||

Have a look at this url:

http://msdn2.microsoft.com/en-us/library/ms143708.aspx

Best regards

- Jens

New to SQL 2000 Reporting Services - Need Some Help

I am trying to get SQL 2000 reporting services up and running, and am trying to get a condensed explanation of what I need to do, and any other software I may need to purchase.

I have already installed the Reporting Services, and after reading the help, it seems that I have to install MS Visual Studio 2003 in order to design the reports. Is this true.

Anyone that can give me some help in getting this up and running - I would be grateful.

Thanks so much - Joe

This is correct, to design reports there is an extension project system that is available for VS 2003, you must install VS and then re-run Reporting Services Setup so it can install the client bits.

SQL Server 2005 does not require you to buy a copy of VS as it includes a cut down copy. To design reports for SQL 2005 you need VS 2005, the versions don't cross over.

sql

new to sql - trying to convert vb function to udf

Hi

I'm an Access/VB coder by experience and trying to move apps to SQL Server 2000.
I have got to grips with the basics of DTS and tables and views and Stored Procedures (to an extent) but now need to upgrade an app that uses a vb function to produce a phased value for a set of budgets.

The VB function looks like this...

----------
Function calcPercentOfBudget(datFromDate As Date, datToDate As Date, iMonth As Integer, cBudget As Currency) As Currency

Dim iDuration As Integer
iDuration = DateDiff("d", datFromDate, datToDate) + 1

' if either date not in current year then 0 (both dates should be in same year)
If Year(datFromDate) <> Year(Now) Or Year(datToDate) <> Year(Now) Then
calcPercentOfBudget = 0
End If

Dim sRatio As Single, idaysInMonth As Integer, idaysInYear As Integer

' if passed month outside of period then 0
If Not (iMonth >= Month(datFromDate) And iMonth <= Month(datToDate)) Then
calcPercentOfBudget = 0
Exit Function
End If

idaysInMonth = daysInMonth(iMonth, Year(Now))


'if from date and to date in same month then 100% of budget
If Month(datFromDate) = Month(datToDate) Then
calcPercentOfBudget = cBudget
Exit Function
End If

' if passed month in From month then ratio of passed month (caters for 1st day of month - 100%)
If Month(datFromDate) = iMonth Then
'calcPercentOfBudget = (idaysInMonth + 1 - Day(datFromDate)) / idaysInYear * cBudget
calcPercentOfBudget = (idaysInMonth + 1 - Day(datFromDate)) / iDuration * cBudget
Exit Function
End If

'if passed month in To month then ratio of passed month (caters for last day of month - 100%)
If Month(datToDate) = iMonth Then
'calcPercentOfBudget = Day(datToDate) / idaysInYear * cBudget
calcPercentOfBudget = Day(datToDate) / iDuration * cBudget
Exit Function
End If

' if passed month within period then 100%
If iMonth > Month(datFromDate) And iMonth < Month(datToDate) Then
'calcPercentOfBudget = idaysInMonth / idaysInYear * cBudget
calcPercentOfBudget = idaysInMonth / iDuration * cBudget
Exit Function
End If

End Function
----------
Function daysInMonth(iMonth As Integer, iYear As Integer) As Integer

Dim datTemp As Date

datTemp = CDate("1/" & CStr(iMonth) & "/" & CStr(iYear))
datTemp = DateAdd("m", 1, datTemp)
datTemp = DateAdd("d", -1, datTemp)

daysInMonth = Day(datTemp)

End Function
----------

I have a UDF function LastDayInMonth to replace the daysInMonth vb function, and that works fine.

However I'm starting to get frustrated in trying to convert the main VB funciton to a UDF function. This is what I have got to, and as you'll see its totally wrong!...

CREATE FUNCTION [dbo].[calcPercentOfBudget] (@.datFrom as datetime, @.datTo as datetime , @.iMonth as int, @.cBudget as money, @.GetDate as datetime)
RETURNS money AS
BEGIN
declare @.iDuration int
declare @.returnvalue money
declare @.sRatio decimal
declare @.iDaysInMonth int

set @.iDuration = datediff(d, @.datFrom, @.datTo)
set @.iDaysinMonth = dbo.LastDayInMonth('1/' + cast(@.iMonth as varchar) + '/' + cast(year(@.getdate) as varchar))

case
when year(@.datFrom) <> year(@.getdate) or year(@.datTo) <> year(@.getdate)
set @.returnvalue = 0
when not(@.iMonth >= Month(@.datFrom) and @.iMonth <= month(@.datTo)
set @.returnvalue 0
when month(@.datFrom) = month(@.datTo)
@.set @.returnvalue = @.cBudget
when month(@.datFrom) = @.iMonth
set @.returnvalue = (@.iDaysInMonth + 1 - day(@.datFrom)) / @.iDuration * @.cBudget
when month(@.datTo) = @.iMonth
set @.returnvalue = Day(datToDate) / iDuration * cBudget
when @.iMonth > month(@.datFrom) and @.iMonth < month(@.datTo)
set @.returnvalue = @.iDaysInMonth / @.iDuration * @.cBudget
end

return @.returnvalue
END

This is my first post to this forum - so any constructive criticism will be welcomed.

Basically, where am I going wrong? - have I got the wrong end of the stick? Have I got the wrong stick? Have I got a stick of dynamite?!

All help greatfully received,
Paul:eek:Case statements work a little differently in T-SQL. Try this:

CREATE FUNCTION [dbo].[calcPercentOfBudget] (@.datFrom as datetime, @.datTo as datetime , @.iMonth as int, @.cBudget as money, @.GetDate as datetime)
RETURNS money AS
BEGIN
declare @.iDuration int
declare @.returnvalue money
declare @.sRatio decimal
declare @.iDaysInMonth int

set @.iDuration = datediff(d, @.datFrom, @.datTo)
set @.iDaysinMonth = dbo.LastDayInMonth('1/' + cast(@.iMonth as varchar) + '/' + cast(year(@.getdate) as varchar))

select @.returnvalue =
case when year(@.datFrom) <> year(@.getdate) or year(@.datTo) <> year(@.getdate) then 0
when not(@.iMonth >= Month(@.datFrom) and @.iMonth <= month(@.datTo) then 0
when month(@.datFrom) = month(@.datTo) then @.cBudget
when month(@.datFrom) = @.iMonth then (@.iDaysInMonth + 1 - day(@.datFrom)) / @.iDuration * @.cBudget
when month(@.datTo) = @.iMonth then Day(datToDate) / iDuration * cBudget
when @.iMonth > month(@.datFrom) and @.iMonth < month(@.datTo) then @.iDaysInMonth / @.iDuration * @.cBudget
end

return @.returnvalue
END

Case in T-SQL returns a value, rather than executes a block of code.|||fantastic, after a couple of other debugs from translation I have a result that works!

Many thanks :)

New to SQL - Please help

Please excues my ignorance, but I am in no way a SQL guy; so here goes:
I have an accounting package that uses SQL 2000. SQL is creating a backup
file that is getting HUGE (about 2 GB)
The actual data is around a few hundred MB.
Is there a way to reduce the size of the backup file by:
Compacting?
Performaing a backup (that SQL knows about)?
Is there a way to move that file?
Can any of this be done on-line?
Thanks for any help.
Regards;
PBWelcome to SQL
Try doing the following at a time when the database has
few or no users.
Right Click on the Database and select Properties
Select Options Tab
Under Recovery - Model if its not set to simple change it
to simple.
Press OK
Right Click the database and select All Tasks -> Shrink
Database
Select the check box 'Move Pages to beginning...'
Press ok
Go make yourself a drink whilst your waiting ;)
And after if finishes change your 'Recovery - Model' back
to what it was prior to your change.
Peter
>--Original Message--
>Please excues my ignorance, but I am in no way a SQL guy;
so here goes:
>I have an accounting package that uses SQL 2000. SQL is
creating a backup
>file that is getting HUGE (about 2 GB)
>The actual data is around a few hundred MB.
>Is there a way to reduce the size of the backup file by:
>Compacting?
>Performaing a backup (that SQL knows about)?
>Is there a way to move that file?
>Can any of this be done on-line?
>Thanks for any help.
>Regards;
>PB
>
>.
>|||Please forgive my ignorance, but:
Where is the database? It appears that the app that uses SQL is pointing to
a file share on another server. The backup file (BAK) is local, and it is
killing me. As I said, it is 2 GB and growing.
If it is the BAK file that is huge; will that fix my problem? The database
itself is only 132 MB.
TIA;
PB
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:44e901c47fb8$3fa1b9d0$a401280a@.phx.gbl...
> Welcome to SQL
> Try doing the following at a time when the database has
> few or no users.
> Right Click on the Database and select Properties
> Select Options Tab
> Under Recovery - Model if its not set to simple change it
> to simple.
> Press OK
> Right Click the database and select All Tasks -> Shrink
> Database
> Select the check box 'Move Pages to beginning...'
> Press ok
> Go make yourself a drink whilst your waiting ;)
> And after if finishes change your 'Recovery - Model' back
> to what it was prior to your change.
> Peter
>
>
> >--Original Message--
> >Please excues my ignorance, but I am in no way a SQL guy;
> so here goes:
> >
> >I have an accounting package that uses SQL 2000. SQL is
> creating a backup
> >file that is getting HUGE (about 2 GB)
> >
> >The actual data is around a few hundred MB.
> >
> >Is there a way to reduce the size of the backup file by:
> >
> >Compacting?
> >Performaing a backup (that SQL knows about)?
> >
> >Is there a way to move that file?
> >
> >Can any of this be done on-line?
> >
> >Thanks for any help.
> >
> >Regards;
> >
> >PB
> >
> >
> >
> >.
> >|||When releasing space SQL Server doesn't actually free
disk space, its thinking is if its needed it before, it
needs it now, so if you say delete half your database you
will see the same disk space.
The problem though is probably to do with your log file
that will grows a heck of a lot.
To work out where your files are click onto your database
then at the top menu selecy view 'Something (I'm away
from SQL) pad'
It will give you the location and size of your data files
and log files.
These files can be anywhere on your Network.
As for your backup files (.BAK) its considered good
practice to store them on a different server than the one
that SQL is on.
And yes, performing the steps will solve the problem as
the steps will release the unused disk space and so the
backups will not be fooled into thinking there is more to
the files than there actually is.
Anyway its 22:15 here and I am off to do something else.
Good luck
Peter
Peter
>--Original Message--
>Please forgive my ignorance, but:
>Where is the database? It appears that the app that uses
SQL is pointing to
>a file share on another server. The backup file (BAK) is
local, and it is
>killing me. As I said, it is 2 GB and growing.
>If it is the BAK file that is huge; will that fix my
problem? The database
>itself is only 132 MB.
>TIA;
>PB
>
>"Peter The Spate" <anonymous@.discussions.microsoft.com>
wrote in message
>news:44e901c47fb8$3fa1b9d0$a401280a@.phx.gbl...
>> Welcome to SQL
>> Try doing the following at a time when the database has
>> few or no users.
>> Right Click on the Database and select Properties
>> Select Options Tab
>> Under Recovery - Model if its not set to simple change
it
>> to simple.
>> Press OK
>> Right Click the database and select All Tasks -> Shrink
>> Database
>> Select the check box 'Move Pages to beginning...'
>> Press ok
>> Go make yourself a drink whilst your waiting ;)
>> And after if finishes change your 'Recovery - Model'
back
>> to what it was prior to your change.
>> Peter
>>
>>
>> >--Original Message--
>> >Please excues my ignorance, but I am in no way a SQL
guy;
>> so here goes:
>> >
>> >I have an accounting package that uses SQL 2000. SQL
is
>> creating a backup
>> >file that is getting HUGE (about 2 GB)
>> >
>> >The actual data is around a few hundred MB.
>> >
>> >Is there a way to reduce the size of the backup file
by:
>> >
>> >Compacting?
>> >Performaing a backup (that SQL knows about)?
>> >
>> >Is there a way to move that file?
>> >
>> >Can any of this be done on-line?
>> >
>> >Thanks for any help.
>> >
>> >Regards;
>> >
>> >PB
>> >
>> >
>> >
>> >.
>> >
>
>.
>|||Are you appending each backup to your existing backup set?
If so then your backup file will continue to grow.
If you are using Enterprise Manager to do the backup,
check this:
R-click the database you want to back up.
Select 'All Tasks-->Backup Database' and in the 'General'
tab have a look at the 'Append to media' option - if this
is set then change it to check the 'Overwrite Existing
media' option instead.
Doing this will leave you with only the current backup so
you might want to set up a database maintenance plan
instead to handle your backups.
HTH
John
>--Original Message--
>Please excues my ignorance, but I am in no way a SQL guy;
so here goes:
>I have an accounting package that uses SQL 2000. SQL is
creating a backup
>file that is getting HUGE (about 2 GB)
>The actual data is around a few hundred MB.
>Is there a way to reduce the size of the backup file by:
>Compacting?
>Performaing a backup (that SQL knows about)?
>Is there a way to move that file?
>Can any of this be done on-line?
>Thanks for any help.
>Regards;
>PB
>
>.
>

New to SQL - Please help

Welcome to SQL
Try doing the following at a time when the database has
few or no users.
Right Click on the Database and select Properties
Select Options Tab
Under Recovery - Model if its not set to simple change it
to simple.
Press OK
Right Click the database and select All Tasks -> Shrink
Database
Select the check box 'Move Pages to beginning...'
Press ok
Go make yourself a drink whilst your waiting ;)
And after if finishes change your 'Recovery - Model' back
to what it was prior to your change.
Peter

>--Original Message--
>Please excues my ignorance, but I am in no way a SQL guy;
so here goes:
>I have an accounting package that uses SQL 2000. SQL is
creating a backup
>file that is getting HUGE (about 2 GB)
>The actual data is around a few hundred MB.
>Is there a way to reduce the size of the backup file by:
>Compacting?
>Performaing a backup (that SQL knows about)?
>Is there a way to move that file?
>Can any of this be done on-line?
>Thanks for any help.
>Regards;
>PB
>
>.
>
Please forgive my ignorance, but:
Where is the database? It appears that the app that uses SQL is pointing to
a file share on another server. The backup file (BAK) is local, and it is
killing me. As I said, it is 2 GB and growing.
If it is the BAK file that is huge; will that fix my problem? The database
itself is only 132 MB.
TIA;
PB
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:44e901c47fb8$3fa1b9d0$a401280a@.phx.gbl...[vbcol=seagreen]
> Welcome to SQL
> Try doing the following at a time when the database has
> few or no users.
> Right Click on the Database and select Properties
> Select Options Tab
> Under Recovery - Model if its not set to simple change it
> to simple.
> Press OK
> Right Click the database and select All Tasks -> Shrink
> Database
> Select the check box 'Move Pages to beginning...'
> Press ok
> Go make yourself a drink whilst your waiting ;)
> And after if finishes change your 'Recovery - Model' back
> to what it was prior to your change.
> Peter
>
>
> so here goes:
> creating a backup
|||When releasing space SQL Server doesn't actually free
disk space, its thinking is if its needed it before, it
needs it now, so if you say delete half your database you
will see the same disk space.
The problem though is probably to do with your log file
that will grows a heck of a lot.
To work out where your files are click onto your database
then at the top menu selecy view 'Something (I'm away
from SQL) pad'
It will give you the location and size of your data files
and log files.
These files can be anywhere on your Network.
As for your backup files (.BAK) its considered good
practice to store them on a different server than the one
that SQL is on.
And yes, performing the steps will solve the problem as
the steps will release the unused disk space and so the
backups will not be fooled into thinking there is more to
the files than there actually is.
Anyway its 22:15 here and I am off to do something else.
Good luck
Peter
Peter

>--Original Message--
>Please forgive my ignorance, but:
>Where is the database? It appears that the app that uses
SQL is pointing to
>a file share on another server. The backup file (BAK) is
local, and it is
>killing me. As I said, it is 2 GB and growing.
>If it is the BAK file that is huge; will that fix my
problem? The database
>itself is only 132 MB.
>TIA;
>PB
>
>"Peter The Spate" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:44e901c47fb8$3fa1b9d0$a401280a@.phx.gbl...
it[vbcol=seagreen]
back[vbcol=seagreen]
guy;[vbcol=seagreen]
is[vbcol=seagreen]
by:
>
>.
>