VPN connection to an SQL Server and/or database

Hi All

Can we connect remotely using SQL Server Enterprise Manager from our
home PCs using a VPN connection, across the Internet, to an instance
of SQL Server(or a database on it) that resides on an ISP's Server?
Can this be done using a VPN IP connection? I believe a static IP is
required for this?

Thanks in Advance, MichaelIn article <8a68c00d.0310180406.41af69bf@.posting.google.com>,
MikeTheBike@.tpgi.com.au says...
> Hi All
> Can we connect remotely using SQL Server Enterprise Manager from our
> home PCs using a VPN connection, across the Internet, to an instance
> of SQL Server(or a database on it) that resides on an ISP's Server?
> Can this be done using a VPN IP connection? I believe a static IP is
> required for this?
> Thanks in Advance, Michael

You don't need a fixed IP to use VPN, but if the destination has a fixed
IP it makes it easier to find the next time.

If the SQL server doesn't have a fixed IP then you are asking for
trouble.

It's standard practice for workers at home to have dynamic IP's and the
office to have fixed IP's.

--
--
spamfree999@.rrohio.com
(Remove 999 to reply to me)|||Hi

There is not reason why this should not work, although if you are not
part of the domain or on a trusted domain then you will probably have
to use SQL authentication.

I don't think a static IP is absolutely necessary, but it may be
required by the firewall/router for authentication.

John

MikeTheBike@.tpgi.com.au (Michael Holberton) wrote in message news:<8a68c00d.0310180406.41af69bf@.posting.google.com>...
> Hi All
> Can we connect remotely using SQL Server Enterprise Manager from our
> home PCs using a VPN connection, across the Internet, to an instance
> of SQL Server(or a database on it) that resides on an ISP's Server?
> Can this be done using a VPN IP connection? I believe a static IP is
> required for this?
> Thanks in Advance, Michael|||Hi John,

Thanks for your response. I couldn't set up a VPN connection but I was
able to connect directly, using the IP Address, using Enterprise
Manager. I had a brainwave earlier today and discovered I could also
setup an ODBC connection using the IP Address and hence link to Tables
from Access.

Regards Michael

jrm_bell@.hotmail.com (John Bell) wrote in message news:<59c6a934.0310181029.1ffcf5ed@.posting.google.com>...
> Hi
> There is not reason why this should not work, although if you are not
> part of the domain or on a trusted domain then you will probably have
> to use SQL authentication.
> I don't think a static IP is absolutely necessary, but it may be
> required by the firewall/router for authentication.
> John|||Hi

If you are not using the VPN and have access restricted to those connecting
though the VPN then anyone can connect!!

John

"Michael Holberton" <MikeTheBike@.tpgi.com.au> wrote in message
news:8a68c00d.0310200113.2586be5d@.posting.google.c om...
> Hi John,
> Thanks for your response. I couldn't set up a VPN connection but I was
> able to connect directly, using the IP Address, using Enterprise
> Manager. I had a brainwave earlier today and discovered I could also
> setup an ODBC connection using the IP Address and hence link to Tables
> from Access.
> Regards Michael
> jrm_bell@.hotmail.com (John Bell) wrote in message
news:<59c6a934.0310181029.1ffcf5ed@.posting.google.com>...
> > Hi
> > There is not reason why this should not work, although if you are not
> > part of the domain or on a trusted domain then you will probably have
> > to use SQL authentication.
> > I don't think a static IP is absolutely necessary, but it may be
> > required by the firewall/router for authentication.
> > John

:( Please Help Needed on Printing Report in RS

Hi All Experts,
I caught in a big problem, previosly our application was using Crystal
Report, but on my suggestion Project Manager changed the reporting tool
for next client and we are decided to use RS and removed CR from our
application.
There are 50 Reports, we designed it well and we dont find any
problems. But out of those reports, two reports are autoprint reports.
The scenario is, i want to print a report which accepts parameter
without user interaction (there might be any number of pages) at server
side (This is a Major Feature of our application). I used Printer
Deliver Sample, but it is time or data driven , but i want to do this
job through my code, means at certain line of code i have to print the
report. Also Delivery Extension uses static parameter, how do i change
it runtime? I also used RsClientprint but it shows printer dialog which
i dont want to show.
Please help me, all eyes in my team are looking towards me like i did a
wrong decision. I am very thankful to all if i receive the solution.
Thank You
Regards
Rajone thing i forgot, i want to print this report in Printed Stationary
with duplicate on same page, means i have to set right, left, top and
bottom margin, i used ReportRender Method, in which i converted report
into EMF and send the stream to printer but i am not able to set
margins, also i am not getting report print what i designed|||Raj,
The "Print a report from a console app" download from this site might
be of help to you. http://www.gotreportviewer.com/
Andy Pottersql

/3GB not working

Hi,

I am on a box with 4 GB of memory that only runs SQL Server. SQL Server is using 1.7 GB as per task manager. There are a lot of databases on this box. I looked at the boot.ini and /3GB was not set. I have done this at least 50 times before: turn on the /3GB switch and SQL Server will use up to 2.7 GB per task manager. (I know it is actually 2GB and 3GB but it seems that in task manager it shows up as 1.7-1.8 and 2.7-2.8)

Anyway back to the story. So I set /3GB, rebooted the server and SQL Server still only consumes up to 1.7GB. I realize that SQL Server might not actually need more memory, but I have a distinct feeling that it wants more but is being constrained; that is, the the /3GB switch is not working. More relevant information:

1) the boot.ini line:
multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced Server" /fastdetect /3GB

2) max server memory (MB) = 3000

3) min server memory (MB) = 3000

4) awe enabled = 0

5) @.@.version = 8.00.2039 which is SQL Server 2000 SP4

Has anyone seen this before? Any ideas on how to troubleshoot this?Just figured out the problem: This server is using SQL Server 2000 Standard Edition. For the benefit of all future readers of this thread, the maximum amount of memory that SQL Server 2000 Standard Edition and SQL Server 2000 Personal Edition can ever use is 2GB. SQL Server 2000 Developer's Edition and SQL Server 2000 Enterprise Edition will both go higher. The actual amount of memory is dependent on the operating system.

.NET2 SMO Components

I am new in VS2005 and I start with sql2005 express. I plan to use SQL express 2005 manager.

When I tries to install this program the system asks for MS Framework,net2 SMO Components.

Where can I download these components?

Thank You

Best regards

?yvind

All of the information needed to install and run Management Studio Express is at http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en. If you still have questions after installing the required components, please let us know.

Peter

|||

The reason for original post was to get source from where the SMO components for .NET could be downloaded so that SQL Manager could be installed properly. And what you did is just posted the link from where SQL Manager could be downloaded.

|||At this point there isn't a separate SMO package. You have to install SS2005 express on the same computer you're installing SSMEE.|||See this link which contains a reference to the SMO redist : http://blogs.msdn.com/mwories/articles/smofaq.aspx|||I stand officially corrected.

.NET2 SMO Components

I am new in VS2005 and I start with sql2005 express. I plan to use SQL express 2005 manager.

When I tries to install this program the system asks for MS Framework,net2 SMO Components.

Where can I download these components?

Thank You

Best regards

?yvind

All of the information needed to install and run Management Studio Express is at http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en. If you still have questions after installing the required components, please let us know.

Peter

|||

The reason for original post was to get source from where the SMO components for .NET could be downloaded so that SQL Manager could be installed properly. And what you did is just posted the link from where SQL Manager could be downloaded.

|||At this point there isn't a separate SMO package. You have to install SS2005 express on the same computer you're installing SSMEE.|||See this link which contains a reference to the SMO redist : http://blogs.msdn.com/mwories/articles/smofaq.aspx|||I stand officially corrected.

.net 1.1 and SQL Server 2005

Hi,

I run .net 1.1, VS2003 with SQL Server Enterprise Manager v 8.0 on my home XP Pro machine.

I have recently purchased some hosting with SQL Server 2005 capabilities. I was in a real rush but I should have checked I suppose.

I would love to be able to use my Enterprise Manager but obviously that wont work as it isnt compatible with 2005. It would be preferable not to have to use the web based admin and I have been told I have to install Microsoft SQL Server Management Studio Express, which requires .net 2.0 to be installed. It seems a bit of a mess really.

Can anyone enlighten me as to what options I have?

Thanks,

Pete

You're already looking at the best option, but incorrectly assuming it's a mess. It isn't. The two framework versions are independent and play fine together, and just doing the default installs should give you wahat you need in not much more time than it takes to download the files.

Jeff

|||

ah OK Jeff thanks,

I shall give it a go!

Pete

|||

Can anyone tell me why 2003 isn't compatible with 2005?

Not a gripe, just curious...

|||

2003 what and 2005 what?

Jeff

|||

Oops,

Well, the whole .net 2 / SQL Server 2005 thing.

Why cant I log in to 2005 server using my Enterprise manager 8.0 ... :)

.MDF and .LDF files that are Read Only

I have a pair of .MDF and .LDF files that I attached to my SQL 2000 server
from the Enterprise Manager. But when the Attach Process was complete, the
icon for that new database was grayed out and it has a (Read-Only) next to
it. After I gave myself every single permission on the SQL server, the
system still won't let me change the configuration properties.
What do I do next?
A couple of guesses here. Was the db in a non-recovered state when you
detached it or was it even properly detached? Are the files them selves set
to Read Only or is the Archive bit set?
Andrew J. Kelly SQL MVP
"racky" <racky@.discussions.microsoft.com> wrote in message
news:8E7FB560-5343-40DD-BEAA-D93C2EB1F265@.microsoft.com...
>I have a pair of .MDF and .LDF files that I attached to my SQL 2000 server
> from the Enterprise Manager. But when the Attach Process was complete,
> the
> icon for that new database was grayed out and it has a (Read-Only) next to
> it. After I gave myself every single permission on the SQL server, the
> system still won't let me change the configuration properties.
> What do I do next?
|||Try the following command:
ALTER DATABASE databasename SET READ_WRITE
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OG9213wsEHA.2556@.tk2msftngp13.phx.gbl...
> A couple of guesses here. Was the db in a non-recovered state when you
> detached it or was it even properly detached? Are the files them selves
set[vbcol=seagreen]
> to Read Only or is the Archive bit set?
> --
> Andrew J. Kelly SQL MVP
>
> "racky" <racky@.discussions.microsoft.com> wrote in message
> news:8E7FB560-5343-40DD-BEAA-D93C2EB1F265@.microsoft.com...
server[vbcol=seagreen]
to
>
|||I hope he already tried that but your right<g>.
Andrew J. Kelly SQL MVP
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:ecGC278sEHA.3460@.TK2MSFTNGP15.phx.gbl...
> Try the following command:
> ALTER DATABASE databasename SET READ_WRITE
>
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OG9213wsEHA.2556@.tk2msftngp13.phx.gbl...
> set
> server
> to
>

.ldf log file

Hi everybody, I have a 10.2Gb .ldf file that is giving me hard disk space problems. We already empty the file with the Enterprise Manager, but the file
still weigths the same...
Is there any procedure shrink this file??
thanks in advanceHi everybody, I have a 10.2Gb .ldf file that is giving me hard disk space problems. We already empty the file with the Enterprise Manager, but the file
still weigths the same...
Is there any procedure shrink this file??
thanks in advance

go to the database in question, type in CHECKPOINT. Wait a little while, then run a shrinkdb. If you are not going to be doing log backups, you need to set the recovery mode to Simple so you don't keep having trouble with this though. After you set it to simple, you can run a shrinkdb and you'll be fine.|||thanks,!
that worked pretty good...
regards,

.bak file is incorrectly formed error

I create a backup file in Enterprise Manager on SQL Server 2000. When I try
to restore this file using SQL Server 2005 Express on another machine, I get
the error "The media family on [my .bak file] is incorrectly formed. SQL
Server cannot process this media family. RESTORE HEADER is terminating
abnormally. (Error 3241)."
This same process has worked successfully several times, the last time in
September 2007. A backup file created in December 2006 will restore. What
has changed to cause this error now and how can it be fixed?
Thanking you in anticipation.I'd re-create the backup file, this should work. And, to be certain that the right steps are taken,
I'd do both the backup and the restore using TSQL commands instead of the GUI (BACKUP DTABASE and
RESTORE DATABASE).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Roger Withnell" <RogerWithnell@.discussions.microsoft.com> wrote in message
news:481F37E4-F944-4F1C-A738-0075F7E2BD05@.microsoft.com...
>I create a backup file in Enterprise Manager on SQL Server 2000. When I try
> to restore this file using SQL Server 2005 Express on another machine, I get
> the error "The media family on [my .bak file] is incorrectly formed. SQL
> Server cannot process this media family. RESTORE HEADER is terminating
> abnormally. (Error 3241)."
> This same process has worked successfully several times, the last time in
> September 2007. A backup file created in December 2006 will restore. What
> has changed to cause this error now and how can it be fixed?
> Thanking you in anticipation.|||Thanks for this, but it didn't fix the problem.
Process is:
1 Use DTS to make a copy of operational database into laptop1 (this has SQL
server 2000). (Use of BACKUP DATABASE is prohibited on the operational
server, which is in a shared environment).
2 Make a backup with TSQL in laptop1 (I can restore from this backup in
laptop1 successfully).
3 Restore with this backup on laptop2 (running SQL Server 2005) using TSQL
gives the same error.
TSQL used is simply BACKUP/RESTORE DATABASE dbname TO/FROM DISK ='C:\...\file.bak
This process has worked successfully in the past. Last accomplished in
September 2007.
Thanking you in anticipation.
Roger
"Tibor Karaszi" wrote:
> I'd re-create the backup file, this should work. And, to be certain that the right steps are taken,
> I'd do both the backup and the restore using TSQL commands instead of the GUI (BACKUP DTABASE and
> RESTORE DATABASE).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Roger Withnell" <RogerWithnell@.discussions.microsoft.com> wrote in message
> news:481F37E4-F944-4F1C-A738-0075F7E2BD05@.microsoft.com...
> >I create a backup file in Enterprise Manager on SQL Server 2000. When I try
> > to restore this file using SQL Server 2005 Express on another machine, I get
> > the error "The media family on [my .bak file] is incorrectly formed. SQL
> > Server cannot process this media family. RESTORE HEADER is terminating
> > abnormally. (Error 3241)."
> >
> > This same process has worked successfully several times, the last time in
> > September 2007. A backup file created in December 2006 will restore. What
> > has changed to cause this error now and how can it be fixed?
> >
> > Thanking you in anticipation.
>|||I see. So you have a 2000 backup, which restores successfully on 2000. But the same backup file
generates below error if you try to restore on 2005:
"The media family on [my .bak file] is incorrectly formed. SQL Server cannot process this media
family. RESTORE HEADER is terminating abnormally. (Error 3241)."
I would either assume that you don't really restore from the same file, or that some file copy
operation from laptop 1 to laptop 2 was unsuccessful. If you are 100% certain that it really is the
same file, then I'd open a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Roger Withnell" <RogerWithnell@.discussions.microsoft.com> wrote in message
news:F9BB51AA-2EE6-4C2E-98FB-62A3423BB0A4@.microsoft.com...
> Thanks for this, but it didn't fix the problem.
> Process is:
> 1 Use DTS to make a copy of operational database into laptop1 (this has SQL
> server 2000). (Use of BACKUP DATABASE is prohibited on the operational
> server, which is in a shared environment).
> 2 Make a backup with TSQL in laptop1 (I can restore from this backup in
> laptop1 successfully).
> 3 Restore with this backup on laptop2 (running SQL Server 2005) using TSQL
> gives the same error.
> TSQL used is simply BACKUP/RESTORE DATABASE dbname TO/FROM DISK => 'C:\...\file.bak
> This process has worked successfully in the past. Last accomplished in
> September 2007.
> Thanking you in anticipation.
> Roger
> "Tibor Karaszi" wrote:
>> I'd re-create the backup file, this should work. And, to be certain that the right steps are
>> taken,
>> I'd do both the backup and the restore using TSQL commands instead of the GUI (BACKUP DTABASE and
>> RESTORE DATABASE).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Roger Withnell" <RogerWithnell@.discussions.microsoft.com> wrote in message
>> news:481F37E4-F944-4F1C-A738-0075F7E2BD05@.microsoft.com...
>> >I create a backup file in Enterprise Manager on SQL Server 2000. When I try
>> > to restore this file using SQL Server 2005 Express on another machine, I get
>> > the error "The media family on [my .bak file] is incorrectly formed. SQL
>> > Server cannot process this media family. RESTORE HEADER is terminating
>> > abnormally. (Error 3241)."
>> >
>> > This same process has worked successfully several times, the last time in
>> > September 2007. A backup file created in December 2006 will restore. What
>> > has changed to cause this error now and how can it be fixed?
>> >
>> > Thanking you in anticipation.|||"Roger Withnell" <RogerWithnell@.discussions.microsoft.com> wrote in message
news:F9BB51AA-2EE6-4C2E-98FB-62A3423BB0A4@.microsoft.com...
> Thanks for this, but it didn't fix the problem.
> Process is:
> 1 Use DTS to make a copy of operational database into laptop1 (this has
> SQL
> server 2000). (Use of BACKUP DATABASE is prohibited on the operational
> server, which is in a shared environment).
I'm curious why BACKUP DATABASE is prohibited.
In my experience DTS never quite got the "copy db" process down well.
> 2 Make a backup with TSQL in laptop1 (I can restore from this backup in
> laptop1 successfully).
> 3 Restore with this backup on laptop2 (running SQL Server 2005) using
> TSQL
> gives the same error.
Hmm, obvious questions, like "32 bit vs 64 bit?" or different language?
And compression on the 2nd laptop?
> TSQL used is simply BACKUP/RESTORE DATABASE dbname TO/FROM DISK => 'C:\...\file.bak
> This process has worked successfully in the past. Last accomplished in
> September 2007.
> Thanking you in anticipation.
> Roger
> "Tibor Karaszi" wrote:
>> I'd re-create the backup file, this should work. And, to be certain that
>> the right steps are taken,
>> I'd do both the backup and the restore using TSQL commands instead of the
>> GUI (BACKUP DTABASE and
>> RESTORE DATABASE).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Roger Withnell" <RogerWithnell@.discussions.microsoft.com> wrote in
>> message
>> news:481F37E4-F944-4F1C-A738-0075F7E2BD05@.microsoft.com...
>> >I create a backup file in Enterprise Manager on SQL Server 2000. When I
>> >try
>> > to restore this file using SQL Server 2005 Express on another machine,
>> > I get
>> > the error "The media family on [my .bak file] is incorrectly formed.
>> > SQL
>> > Server cannot process this media family. RESTORE HEADER is terminating
>> > abnormally. (Error 3241)."
>> >
>> > This same process has worked successfully several times, the last time
>> > in
>> > September 2007. A backup file created in December 2006 will restore.
>> > What
>> > has changed to cause this error now and how can it be fixed?
>> >
>> > Thanking you in anticipation.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

.bak file is incorrectly formed error

I create a backup file in Enterprise Manager on SQL Server 2000. When I try
to restore this file using SQL Server 2005 Express on another machine, I get
the error "The media family on [my .bak file] is incorrectly formed. SQL
Server cannot process this media family. RESTORE HEADER is terminating
abnormally. (Error 3241)."
This same process has worked successfully several times, the last time in
September 2007. A backup file created in December 2006 will restore. What
has changed to cause this error now and how can it be fixed?
Thanking you in anticipation.
Thanks for this, but it didn't fix the problem.
Process is:
1 Use DTS to make a copy of operational database into laptop1 (this has SQL
server 2000). (Use of BACKUP DATABASE is prohibited on the operational
server, which is in a shared environment).
2 Make a backup with TSQL in laptop1 (I can restore from this backup in
laptop1 successfully).
3 Restore with this backup on laptop2 (running SQL Server 2005) using TSQL
gives the same error.
TSQL used is simply BACKUP/RESTORE DATABASE dbname TO/FROM DISK =
'C:\...\file.bak
This process has worked successfully in the past. Last accomplished in
September 2007.
Thanking you in anticipation.
Roger
"Tibor Karaszi" wrote:

> I'd re-create the backup file, this should work. And, to be certain that the right steps are taken,
> I'd do both the backup and the restore using TSQL commands instead of the GUI (BACKUP DTABASE and
> RESTORE DATABASE).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Roger Withnell" <RogerWithnell@.discussions.microsoft.com> wrote in message
> news:481F37E4-F944-4F1C-A738-0075F7E2BD05@.microsoft.com...
>
|||"Roger Withnell" <RogerWithnell@.discussions.microsoft.com> wrote in message
news:F9BB51AA-2EE6-4C2E-98FB-62A3423BB0A4@.microsoft.com...
> Thanks for this, but it didn't fix the problem.
> Process is:
> 1 Use DTS to make a copy of operational database into laptop1 (this has
> SQL
> server 2000). (Use of BACKUP DATABASE is prohibited on the operational
> server, which is in a shared environment).
I'm curious why BACKUP DATABASE is prohibited.
In my experience DTS never quite got the "copy db" process down well.

> 2 Make a backup with TSQL in laptop1 (I can restore from this backup in
> laptop1 successfully).
> 3 Restore with this backup on laptop2 (running SQL Server 2005) using
> TSQL
> gives the same error.
Hmm, obvious questions, like "32 bit vs 64 bit?" or different language?
And compression on the 2nd laptop?
[vbcol=seagreen]
> TSQL used is simply BACKUP/RESTORE DATABASE dbname TO/FROM DISK =
> 'C:\...\file.bak
> This process has worked successfully in the past. Last accomplished in
> September 2007.
> Thanking you in anticipation.
> Roger
> "Tibor Karaszi" wrote:
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

*.SQL File - Seemingly Easy

The Set-Up:
Remote Shared SQL Server
Local Software - SQL Server Enterprise Manager
.SQL File
The Problem:
I am trying to set up a forum on my website which tells me to use the
supplied .SQL file to set up the tables. How do I go about doing that?
Thanks in advance for any feedback."Ryan" <Ryan@.discussions.microsoft.com> wrote in message
news:D3D230D4-6344-409A-9926-54BC64CBE973@.microsoft.com...
> The Set-Up:
> Remote Shared SQL Server
> Local Software - SQL Server Enterprise Manager
> .SQL File
> The Problem:
> I am trying to set up a forum on my website which tells me to use the
> supplied .SQL file to set up the tables. How do I go about doing that?
> Thanks in advance for any feedback.
Open up Query Analyzer (from EM you can highlight the correct database and
select Tools > Query Analyzer from the main menu). Then in QA, click File >
Open ... and load your .SQL file. Then select Query > Execute (or press
F5).|||Heck ya, thanks lots!

*.SQL File - Seemingly Easy

The Set-Up:
Remote Shared SQL Server
Local Software - SQL Server Enterprise Manager
.SQL File
The Problem:
I am trying to set up a forum on my website which tells me to use the
supplied .SQL file to set up the tables. How do I go about doing that?
Thanks in advance for any feedback."Ryan" <Ryan@.discussions.microsoft.com> wrote in message
news:D3D230D4-6344-409A-9926-54BC64CBE973@.microsoft.com...
> The Set-Up:
> Remote Shared SQL Server
> Local Software - SQL Server Enterprise Manager
> .SQL File
> The Problem:
> I am trying to set up a forum on my website which tells me to use the
> supplied .SQL file to set up the tables. How do I go about doing that?
> Thanks in advance for any feedback.
Open up Query Analyzer (from EM you can highlight the correct database and
select Tools > Query Analyzer from the main menu). Then in QA, click File >
Open ... and load your .SQL file. Then select Query > Execute (or press
F5).|||Heck ya, thanks lots!

**Current Activity(Enterprise Manager)**

Hi
I'm using SQL server 2000 and when I select the current activity in
enterprise manager and want to sort the CPU column ascending, it seels by
clicking on the title of this column it will be sort alphabetically not in
numeric mode,why?
and the second problem is,by looking through this page how can I
understand which users or application are using the resources on server
more? and is there anyway to find if an object locked or busy for a long
time with a special program on specific station?
Fore example: I've a specific procedure that most of time work probably(2
sec) but sometimes it takes a long time to fetch the result (5 min)!! and
by renaming it ,it works well again,can this page help me to find which
station is running this query during that special "5 minute" time?
Any help would be thankfulThe CPU data is probably converted to a character behind the scenes. Take a
look at sp_who2 and sp_lock sp's to get a better picture of what is
happening. These are more flexible than EM and you can look at the code for
them in the master db to see what they are doing. You may also want to run
a trace to capture more information about who is doing what and how long
each takes. Lookup trace or profiler in BooksOnLine.
Andrew J. Kelly SQL MVP
<R> wrote in message news:opssw5yamdmw7tkz@.system109.parskhazar.net...
> Hi
> I'm using SQL server 2000 and when I select the current activity in
> enterprise manager and want to sort the CPU column ascending, it seels by
> clicking on the title of this column it will be sort alphabetically not in
> numeric mode,why?
> and the second problem is,by looking through this page how can I
> understand which users or application are using the resources on server
> more? and is there anyway to find if an object locked or busy for a long
> time with a special program on specific station?
> Fore example: I've a specific procedure that most of time work probably(2
> sec) but sometimes it takes a long time to fetch the result (5 min)!! and
> by renaming it ,it works well again,can this page help me to find which
> station is running this query during that special "5 minute" time?
> Any help would be thankful|||Thanks, I tried to save activities by creating a trace saving result to
table.
Although I filtered it just to save some activities for some logins ,it
needs a lot space to store all details in a table for some days!!!
I want to find a way to record most activities in details to refer to them
later to find who and when sth happened.
can you direct me more?
Thanks a lot|||You should never send a trace directly to a table, especially if it is long
term. You should send the results directly to a file on a local disk drive.
You can then load them into a table later with fn_trace_gettable. Don't use
profiler for this but rather sp_trace_create and it's associated sp's. See
here for more details:
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
--
Andrew J. Kelly SQL MVP
<R> wrote in message news:opss0idcllmw7tkz@.system109.parskhazar.net...
> Thanks, I tried to save activities by creating a trace saving result to
> table.
> Although I filtered it just to save some activities for some logins ,it
> needs a lot space to store all details in a table for some days!!!
> I want to find a way to record most activities in details to refer to them
> later to find who and when sth happened.
> can you direct me more?
> Thanks a lot

**Current Activity(Enterprise Manager)**

Hi
I'm using SQL server 2000 and when I select the current activity in
enterprise manager and want to sort the CPU column ascending, it seels by
clicking on the title of this column it will be sort alphabetically not in
numeric mode,why?
and the second problem is,by looking through this page how can I
understand which users or application are using the resources on server
more? and is there anyway to find if an object locked or busy for a long
time with a special program on specific station?
Fore example: I've a specific procedure that most of time work probably(2
sec) but sometimes it takes a long time to fetch the result (5 min)!! and
by renaming it ,it works well again,can this page help me to find which
station is running this query during that special "5 minute" time?
Any help would be thankfulThe CPU data is probably converted to a character behind the scenes. Take a
look at sp_who2 and sp_lock sp's to get a better picture of what is
happening. These are more flexible than EM and you can look at the code for
them in the master db to see what they are doing. You may also want to run
a trace to capture more information about who is doing what and how long
each takes. Lookup trace or profiler in BooksOnLine.
Andrew J. Kelly SQL MVP
<R> wrote in message news:opssw5yamdmw7tkz@.system109.parskhazar.net...
> Hi
> I'm using SQL server 2000 and when I select the current activity in
> enterprise manager and want to sort the CPU column ascending, it seels by
> clicking on the title of this column it will be sort alphabetically not in
> numeric mode,why?
> and the second problem is,by looking through this page how can I
> understand which users or application are using the resources on server
> more? and is there anyway to find if an object locked or busy for a long
> time with a special program on specific station?
> Fore example: I've a specific procedure that most of time work probably(2
> sec) but sometimes it takes a long time to fetch the result (5 min)!! and
> by renaming it ,it works well again,can this page help me to find which
> station is running this query during that special "5 minute" time?
> Any help would be thankful|||Thanks, I tried to save activities by creating a trace saving result to
table.
Although I filtered it just to save some activities for some logins ,it
needs a lot space to store all details in a table for some days!!!
I want to find a way to record most activities in details to refer to them
later to find who and when sth happened.
can you direct me more?
Thanks a lot|||You should never send a trace directly to a table, especially if it is long
term. You should send the results directly to a file on a local disk drive.
You can then load them into a table later with fn_trace_gettable. Don't use
profiler for this but rather sp_trace_create and it's associated sp's. See
here for more details:
http://vyaskn.tripod.com/server_sid..._sql_server.htm
Andrew J. Kelly SQL MVP
<R> wrote in message news:opss0idcllmw7tkz@.system109.parskhazar.net...
> Thanks, I tried to save activities by creating a trace saving result to
> table.
> Although I filtered it just to save some activities for some logins ,it
> needs a lot space to store all details in a table for some days!!!
> I want to find a way to record most activities in details to refer to them
> later to find who and when sth happened.
> can you direct me more?
> Thanks a lot

**Current Activity(Enterprise Manager)**

Hi
I'm using SQL server 2000 and when I select the current activity in
enterprise manager and want to sort the CPU column ascending, it seels by
clicking on the title of this column it will be sort alphabetically not in
numeric mode,why?
and the second problem is,by looking through this page how can I
understand which users or application are using the resources on server
more? and is there anyway to find if an object locked or busy for a long
time with a special program on specific station?
Fore example: I've a specific procedure that most of time work probably(2
sec) but sometimes it takes a long time to fetch the result (5 min)!! and
by renaming it ,it works well again,can this page help me to find which
station is running this query during that special "5 minute" time?
Any help would be thankful
The CPU data is probably converted to a character behind the scenes. Take a
look at sp_who2 and sp_lock sp's to get a better picture of what is
happening. These are more flexible than EM and you can look at the code for
them in the master db to see what they are doing. You may also want to run
a trace to capture more information about who is doing what and how long
each takes. Lookup trace or profiler in BooksOnLine.
Andrew J. Kelly SQL MVP
<R> wrote in message news:opssw5yamdmw7tkz@.system109.parskhazar.net...
> Hi
> I'm using SQL server 2000 and when I select the current activity in
> enterprise manager and want to sort the CPU column ascending, it seels by
> clicking on the title of this column it will be sort alphabetically not in
> numeric mode,why?
> and the second problem is,by looking through this page how can I
> understand which users or application are using the resources on server
> more? and is there anyway to find if an object locked or busy for a long
> time with a special program on specific station?
> Fore example: I've a specific procedure that most of time work probably(2
> sec) but sometimes it takes a long time to fetch the result (5 min)!! and
> by renaming it ,it works well again,can this page help me to find which
> station is running this query during that special "5 minute" time?
> Any help would be thankful
|||Thanks, I tried to save activities by creating a trace saving result to
table.
Although I filtered it just to save some activities for some logins ,it
needs a lot space to store all details in a table for some days!!!
I want to find a way to record most activities in details to refer to them
later to find who and when sth happened.
can you direct me more?
Thanks a lot
|||You should never send a trace directly to a table, especially if it is long
term. You should send the results directly to a file on a local disk drive.
You can then load them into a table later with fn_trace_gettable. Don't use
profiler for this but rather sp_trace_create and it's associated sp's. See
here for more details:
http://vyaskn.tripod.com/server_side...sql_server.htm
Andrew J. Kelly SQL MVP
<R> wrote in message news:opss0idcllmw7tkz@.system109.parskhazar.net...
> Thanks, I tried to save activities by creating a trace saving result to
> table.
> Although I filtered it just to save some activities for some logins ,it
> needs a lot space to store all details in a table for some days!!!
> I want to find a way to record most activities in details to refer to them
> later to find who and when sth happened.
> can you direct me more?
> Thanks a lot

(Target Server Memory)Perf. Monitor Counters

Why does'nt my Target Server Memory value (2.7 GB) within
Memory Manager in the Performance Monitor Counters match
the values in SQL Server Memory Maximum Value (5.2 GB)
My Target Server Memory displays a value of 2.7 GB and the
SQL Memory Maximum displays 5.2 GB.
The boot.ini is set with the following parameters:
[boot loader]
timeout=10
default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microso ft
Windows 2000 Advanced Server" /fastdetect /3gb /PAE
The server initially had 6GB of RAM and 2GB were added to
the server. SQL Server displays 5.2 GB is the maximum alot
memory and Dynamically configure SQL Server memory.
How can I fix the memory problem.
Thanks,
Mike
Do you have AWE enabled in SQL?
Are you rinning Enterprise Edition SQL?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microso ft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>

(Target Server Memory)Perf. Monitor Counters

Why does'nt my Target Server Memory value (2.7 GB) within
Memory Manager in the Performance Monitor Counters match
the values in SQL Server Memory Maximum Value (5.2 GB)
My Target Server Memory displays a value of 2.7 GB and the
SQL Memory Maximum displays 5.2 GB.
The boot.ini is set with the following parameters:
[boot loader]
timeout=10
default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
Windows 2000 Advanced Server" /fastdetect /3gb /PAE
The server initially had 6GB of RAM and 2GB were added to
the server. SQL Server displays 5.2 GB is the maximum alot
memory and Dynamically configure SQL Server memory.
How can I fix the memory problem.
Thanks,
MikeDo you have AWE enabled in SQL?
Are you rinning Enterprise Edition SQL?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>

(Target Server Memory)Perf. Monitor Counters

Why does'nt my Target Server Memory value (2.7 GB) within
Memory Manager in the Performance Monitor Counters match
the values in SQL Server Memory Maximum Value (5.2 GB)
My Target Server Memory displays a value of 2.7 GB and the
SQL Memory Maximum displays 5.2 GB.
The boot.ini is set with the following parameters:
[boot loader]
timeout=10
default=multi(0)disk(0)rdisk(0)partition
(1)\WINNT
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINN
T="Microsoft
Windows 2000 Advanced Server" /fastdetect /3gb /PAE
The server initially had 6GB of RAM and 2GB were added to
the server. SQL Server displays 5.2 GB is the maximum alot
memory and Dynamically configure SQL Server memory.
How can I fix the memory problem.
Thanks,
MikeDo you have AWE enabled in SQL?
Are you rinning Enterprise Edition SQL?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition
(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINN
T="Microsoft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>