I am using the sql server express manager and when I right click on
stored procedure I have a modify option. I use this, make my changes,
and hit save. But is always saves a separate .sql file and never
changes the original stored procedure. What am I doing wrong? How can
I modify the stored procedure in my database? Thank you for any help.
You have to execute the changing script, NOT saving it, which always
saves the script to a file.
HTH; Jens Suessmeyer.
http://www.sqlserver2005.de
|||Jens wrote:
> You have to execute the changing script, NOT saving it, which always
> saves the script to a file.
> HTH; Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
So you are saying that when I hit modify, change the code, and then hit
Execute (!) and that automatically saves it?
|||needin4mation@.gmail.com wrote:
> Jens wrote:
> So you are saying that when I hit modify, change the code, and then hit
> Execute (!) and that automatically saves it?
>
It's not correct wording to say it's being saved. As Jens says, you'll
have to execute the new stored procedure to get it added to the
database, but that's not the same as saving it...:-). When you save it,
it's being saved as a regular sql file but that will not do anything to
the actual SP in the database.
Regards
Steen
|||right.
Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts
Friday, March 30, 2012
How do I Modify a Stored Procedure?
I am using the sql server express manager and when I right click on
stored procedure I have a modify option. I use this, make my changes,
and hit save. But is always saves a separate .sql file and never
changes the original stored procedure. What am I doing wrong? How can
I modify the stored procedure in my database? Thank you for any help.You have to execute the changing script, NOT saving it, which always
saves the script to a file.
HTH; Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Jens wrote:
> You have to execute the changing script, NOT saving it, which always
> saves the script to a file.
> HTH; Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
So you are saying that when I hit modify, change the code, and then hit
Execute (!) and that automatically saves it?|||needin4mation@.gmail.com wrote:
> Jens wrote:
> So you are saying that when I hit modify, change the code, and then hit
> Execute (!) and that automatically saves it?
>
It's not correct wording to say it's being saved. As Jens says, you'll
have to execute the new stored procedure to get it added to the
database, but that's not the same as saving it...:-). When you save it,
it's being saved as a regular sql file but that will not do anything to
the actual SP in the database.
Regards
Steen|||right.
stored procedure I have a modify option. I use this, make my changes,
and hit save. But is always saves a separate .sql file and never
changes the original stored procedure. What am I doing wrong? How can
I modify the stored procedure in my database? Thank you for any help.You have to execute the changing script, NOT saving it, which always
saves the script to a file.
HTH; Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Jens wrote:
> You have to execute the changing script, NOT saving it, which always
> saves the script to a file.
> HTH; Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
So you are saying that when I hit modify, change the code, and then hit
Execute (!) and that automatically saves it?|||needin4mation@.gmail.com wrote:
> Jens wrote:
> So you are saying that when I hit modify, change the code, and then hit
> Execute (!) and that automatically saves it?
>
It's not correct wording to say it's being saved. As Jens says, you'll
have to execute the new stored procedure to get it added to the
database, but that's not the same as saving it...:-). When you save it,
it's being saved as a regular sql file but that will not do anything to
the actual SP in the database.
Regards
Steen|||right.
How do I Modify a Stored Procedure?
I am using the sql server express manager and when I right click on
stored procedure I have a modify option. I use this, make my changes,
and hit save. But is always saves a separate .sql file and never
changes the original stored procedure. What am I doing wrong? How can
I modify the stored procedure in my database? Thank you for any help.You have to execute the changing script, NOT saving it, which always
saves the script to a file.
HTH; Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Jens wrote:
> You have to execute the changing script, NOT saving it, which always
> saves the script to a file.
> HTH; Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
So you are saying that when I hit modify, change the code, and then hit
Execute (!) and that automatically saves it?|||needin4mation@.gmail.com wrote:
> Jens wrote:
>> You have to execute the changing script, NOT saving it, which always
>> saves the script to a file.
>> HTH; Jens Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
> So you are saying that when I hit modify, change the code, and then hit
> Execute (!) and that automatically saves it?
>
It's not correct wording to say it's being saved. As Jens says, you'll
have to execute the new stored procedure to get it added to the
database, but that's not the same as saving it...:-). When you save it,
it's being saved as a regular sql file but that will not do anything to
the actual SP in the database.
Regards
Steen|||right.sql
stored procedure I have a modify option. I use this, make my changes,
and hit save. But is always saves a separate .sql file and never
changes the original stored procedure. What am I doing wrong? How can
I modify the stored procedure in my database? Thank you for any help.You have to execute the changing script, NOT saving it, which always
saves the script to a file.
HTH; Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Jens wrote:
> You have to execute the changing script, NOT saving it, which always
> saves the script to a file.
> HTH; Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
So you are saying that when I hit modify, change the code, and then hit
Execute (!) and that automatically saves it?|||needin4mation@.gmail.com wrote:
> Jens wrote:
>> You have to execute the changing script, NOT saving it, which always
>> saves the script to a file.
>> HTH; Jens Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
> So you are saying that when I hit modify, change the code, and then hit
> Execute (!) and that automatically saves it?
>
It's not correct wording to say it's being saved. As Jens says, you'll
have to execute the new stored procedure to get it added to the
database, but that's not the same as saving it...:-). When you save it,
it's being saved as a regular sql file but that will not do anything to
the actual SP in the database.
Regards
Steen|||right.sql
Monday, March 26, 2012
How do I install SQL Enterprise Manager?
Hi All,
I'm pretty new to SQL anything... I'm wondering if there is a way to install just Enterprise Manager on my local workstation so I can open it up and manage or at least look at all of the SQL db's that are spread out on various servers - all in one place?
1. How can I install just Enterprise Manager (if possible). I ran setup on SQL2000 Personal Addition and it didn't look like it was going to get to a 'custom setup' screen so I cancelled, it looked like it was going to install SQL Server 2000 and all components (maybe this is what I have to do, I don't know).
2. If I install SQL2000 Enterprise Manager, am I able to access and view SQL 6.5 and SQL 7.0 and SQL 2000 databases all together?
Thanks so much.
Chris
You could install EM only with other client tools: the option is presented in the installer.
|||FYI Em does not support SQL 6.5 or SQL 2005, it does support 7 and 2000|||Thanks everyone! I found them.|||Where did you find them?|||Just keep going through the install of SQL server and it will either bring you to a custom option (where you can choose just the utilities) or it will bring you to a page that you can check a radio button to just install the utilities.
|||Got it thanks!Monday, March 19, 2012
How do I get Table Owner?
I need to the table owner.
Not from in Enterprise Manager, but from my app. (it's written in Delphi).
Any suggestions?
Thank you,
KeithUSE Northwind
GO
DECLARE @.TABLE_NAME sysname
SELECT @.TABLE_NAME = 'Orders'
SELECT TABLE_SCHEMA
FROM INFORMATION_SCHEMA.Tables
WHERE TABLE_NAME = @.TABLE_NAME|||I'd use:SELECT TABLE_SCHEMA AS owner
FROM INFORMATION_SCHEMA.TABLES
WHERE 'myTable' = TABLE_NAME
-PatP
Not from in Enterprise Manager, but from my app. (it's written in Delphi).
Any suggestions?
Thank you,
KeithUSE Northwind
GO
DECLARE @.TABLE_NAME sysname
SELECT @.TABLE_NAME = 'Orders'
SELECT TABLE_SCHEMA
FROM INFORMATION_SCHEMA.Tables
WHERE TABLE_NAME = @.TABLE_NAME|||I'd use:SELECT TABLE_SCHEMA AS owner
FROM INFORMATION_SCHEMA.TABLES
WHERE 'myTable' = TABLE_NAME
-PatP
How do I get rid of SQL Server?
An icon for Microsoft SQL Server Service Manager just started showing
up on my taskbar. I didn't install SQL Server. The icon
starting showing up after I ran Windows Update. SQL Server is not
listed in my Add/Remove programs, and I can't seem to find the
application anywhere on my laptop. I have a new (less than 6
months old) Dell laptop running WinXP Professional. I seem to
have lost my Internet connectivity at about the same time this icon
showed up. I did a system restore back to before I installed the
Windows Update, and the icon disappeared. However, it has now
shown up again. Anybody know what's going on with this?
Does some other app use SQL server? I really need to fix this
problem.
Thx,
j
See Books Online -- How to: Manually Uninstall an Existing Instance of SQL Server 2005
http://msdn2.microsoft.com/en-us/library/aa337087.aspx
|||
Hi
By reading at your description, I can't really tell what has happen to your machine.
But please try the following:
1. From your desktop, right click on "my computer" icon.
2. Select "manage" from the pop-up menu.
3. When "Computer Managment" console pop up, expand "Services and Applications" node on left pane.
4. select "Services" node
5. Now look at the right pane on Computer Management console. It lists all the window services that are available on your machine. Please scrow down the list and see if you can find any service name that starts with "SQL Server"
If there are any listed, could you please post the list for furthur analysis?
Thank you. :-)
|||I'm getting the same message. So I inadvertently (in my jet lag state) removed sqlmanagr.exe from my Add/Remove location. Now my computer is running slowly, does not access the Internet, and my family is ready to disown me.
Pls help - 1) what fixed your problem, and 2) how do I get the service manager back?
Thx,
|||Hi,
Have you installed Visual Studio on your laptop !!? If yes; SQL Server Express is a part of it. Refer earlier given link for manual un-installation.
Hemantgiri S. Goswami
How do I get rid of SQL Server?
An icon for Microsoft SQL Server Service Manager just started showing
up on my taskbar. I didn't install SQL Server. The icon
starting showing up after I ran Windows Update. SQL Server is not
listed in my Add/Remove programs, and I can't seem to find the
application anywhere on my laptop. I have a new (less than 6
months old) Dell laptop running WinXP Professional. I seem to
have lost my Internet connectivity at about the same time this icon
showed up. I did a system restore back to before I installed the
Windows Update, and the icon disappeared. However, it has now
shown up again. Anybody know what's going on with this?
Does some other app use SQL server? I really need to fix this
problem.
Thx,
j
See Books Online -- How to: Manually Uninstall an Existing Instance of SQL Server 2005
http://msdn2.microsoft.com/en-us/library/aa337087.aspx
|||
Hi
By reading at your description, I can't really tell what has happen to your machine.
But please try the following:
1. From your desktop, right click on "my computer" icon.
2. Select "manage" from the pop-up menu.
3. When "Computer Managment" console pop up, expand "Services and Applications" node on left pane.
4. select "Services" node
5. Now look at the right pane on Computer Management console. It lists all the window services that are available on your machine. Please scrow down the list and see if you can find any service name that starts with "SQL Server"
If there are any listed, could you please post the list for furthur analysis?
Thank you. :-)
|||I'm getting the same message. So I inadvertently (in my jet lag state) removed sqlmanagr.exe from my Add/Remove location. Now my computer is running slowly, does not access the Internet, and my family is ready to disown me.
Pls help - 1) what fixed your problem, and 2) how do I get the service manager back?
Thx,
|||Hi,
Have you installed Visual Studio on your laptop !!? If yes; SQL Server Express is a part of it. Refer earlier given link for manual un-installation.
Hemantgiri S. Goswami
How do I get rid of SQL Server?
An icon for Microsoft SQL Server Service Manager just started showing
up on my taskbar. I didn't install SQL Server. The icon
starting showing up after I ran Windows Update. SQL Server is not
listed in my Add/Remove programs, and I can't seem to find the
application anywhere on my laptop. I have a new (less than 6
months old) Dell laptop running WinXP Professional. I seem to
have lost my Internet connectivity at about the same time this icon
showed up. I did a system restore back to before I installed the
Windows Update, and the icon disappeared. However, it has now
shown up again. Anybody know what's going on with this?
Does some other app use SQL server? I really need to fix this
problem.
Thx,
j
See Books Online -- How to: Manually Uninstall an Existing Instance of SQL Server 2005
http://msdn2.microsoft.com/en-us/library/aa337087.aspx
|||
Hi
By reading at your description, I can't really tell what has happen to your machine.
But please try the following:
1. From your desktop, right click on "my computer" icon.
2. Select "manage" from the pop-up menu.
3. When "Computer Managment" console pop up, expand "Services and Applications" node on left pane.
4. select "Services" node
5. Now look at the right pane on Computer Management console. It lists all the window services that are available on your machine. Please scrow down the list and see if you can find any service name that starts with "SQL Server"
If there are any listed, could you please post the list for furthur analysis?
Thank you. :-)
|||I'm getting the same message. So I inadvertently (in my jet lag state) removed sqlmanagr.exe from my Add/Remove location. Now my computer is running slowly, does not access the Internet, and my family is ready to disown me.
Pls help - 1) what fixed your problem, and 2) how do I get the service manager back?
Thx,
|||Hi,
Have you installed Visual Studio on your laptop !!? If yes; SQL Server Express is a part of it. Refer earlier given link for manual un-installation.
Hemantgiri S. Goswami
Friday, March 9, 2012
How do I find out what version of SQL Server 2000 I'm running?
How do I find out what version of SQL Server 2000 I'm running?
The 'about' dialog box on the SQL Server Service Manager
says my version is 8.00.760 but the latest service pack 3
is version 8.00.760.03. I thought I installed this service
pack already.
How can I know for sure?
Thanks
Brad760 is SP3. You have SP3, regardless of the sub-sub-sub-version number.
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad|||Never mind I found out by reading the reply a 8:16 am today.
>--Original Message--
>How do I find out what version of SQL Server 2000 I'm running?
>The 'about' dialog box on the SQL Server Service Manager
>says my version is 8.00.760 but the latest service pack 3
>is version 8.00.760.03. I thought I installed this service
>pack already.
>How can I know for sure?
>Thanks
>Brad
>.
>|||Brad,
The following in the readme file for SP3a. (
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp)
Distinguishing Between SP3 and SP3a
To determine whether you have SP3 or SP3a installed, look at the version
number of the Net-Library file, Ssnetlib.dll. If the version number of this
file is 2000.80.760.0, you have SP3; if the version number of this file is
2000.80.766.0, you have SP3a.
Assuming that an instance was installed using the default settings, you can
find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft
SQLServer\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
To find out whether you have the SP3 or SP3a setup folders, open the
SP3Readme.htm file and read the first page. The service pack version, SP3a
or SP3, is listed at the top of the first page.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad
The 'about' dialog box on the SQL Server Service Manager
says my version is 8.00.760 but the latest service pack 3
is version 8.00.760.03. I thought I installed this service
pack already.
How can I know for sure?
Thanks
Brad760 is SP3. You have SP3, regardless of the sub-sub-sub-version number.
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad|||Never mind I found out by reading the reply a 8:16 am today.
>--Original Message--
>How do I find out what version of SQL Server 2000 I'm running?
>The 'about' dialog box on the SQL Server Service Manager
>says my version is 8.00.760 but the latest service pack 3
>is version 8.00.760.03. I thought I installed this service
>pack already.
>How can I know for sure?
>Thanks
>Brad
>.
>|||Brad,
The following in the readme file for SP3a. (
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp)
Distinguishing Between SP3 and SP3a
To determine whether you have SP3 or SP3a installed, look at the version
number of the Net-Library file, Ssnetlib.dll. If the version number of this
file is 2000.80.760.0, you have SP3; if the version number of this file is
2000.80.766.0, you have SP3a.
Assuming that an instance was installed using the default settings, you can
find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft
SQLServer\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
To find out whether you have the SP3 or SP3a setup folders, open the
SP3Readme.htm file and read the first page. The service pack version, SP3a
or SP3, is listed at the top of the first page.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad
Wednesday, March 7, 2012
How do i enter NULL in a table cell in the Enterprise Manager UI for table data entry?
I have a column defined as smalldatetime. Default length (4), and "allow NULLS" is checked.
In the Enterprise Manager UI, when i enter data into that table row, if i just tab past that column, all is well, and the value is represented in the UI as <NULL>.
The problem comes once i ever enter a date into that column. Say i have entered a date (all is well), and now i want to remove that entry and go back to NULL (after the date value has been committed, different entry session, say).
How is that done?
It seems to me, once a date has ever been entered into that column, now, if i try to remove it, i get the error "The value you entered is not consistant with the data type or length of the column, or over grid buffer limit". I have tried deleting the value, entering spaces, entering the string NULL or the string <NULL>; maybe some other tries as well, but none works, i always get that error message and am not allowed to proceed past that cell until i restore a date value to it. I want to get back to <NULL>.
Anybody know?
Thank you.
Tom
Subscribe to:
Posts (Atom)