We have had to change the hostname on an SQL server (Blade and the balde
moved chassis so name changed)
It seems i need to run 2 stored procedures which are
sp_dropserver 'old_name', 'droplogins'
go
sp_addserver 'new_name', 'local'
go
Assuming this is right I cannot find anyway to run these stored procedures
as there seems ot be no interactiove SQL.
Extreme performance issues (SQL Server 2000/ADO.NET/C#) ... This process runs very quickly if run through Query... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ... (microsoft.public.dotnet.framework.adonet)
Re: Securing Stored Procedures from being seen ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions.... but I would have to know what groups the user belongs... see the names of any stored procedures to which he has no rights. ... (microsoft.public.sqlserver.security)
Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7 ... For parsing a string to a date/time, the 103 format doesn't limits the user ... > which is used as the row source for the results form). ... > other solutions assuming I have to use SQL Server 7? ... > I don't understand how I can use parameterized stored procedures to solve ... (microsoft.public.access.adp.sqlserver)
Re: Limiting views on data in a table ... returns the Windows login the user uses to connect to SQL Server.... > The way I was implementing this was to use Windows Auth with a Windows ... > covered by which salespeople,... > with it via the stored procedures.... (microsoft.public.sqlserver.security)
Re: Help understanding Stored proc Level Secuirty? ... Jasper Smith (SQL Server MVP)... I set permissions to my Stored Procedures,... Access to stored procs fail... (microsoft.public.sqlserver.security)
