Viewing 15 posts - 5,191 through 5,205 (of 7,429 total)
You will have to catch input from them to use at application logon or code API methods if they are NT login and id's are the same.
"Don't roll your eyes...
July 17, 2002 at 11:16 am
I prefer this way as it returns an error specific to where the problem occurred and rollsback all as soon as issue has occurred.
create procedure ip_test
as
begin transaction
statement 1
if @@Error !=...
July 17, 2002 at 11:14 am
Also when you run each way output the Execution Plan and see if they differ in any way.
"Don't roll your eyes at me. I will tape them in place." (Teacher...
July 17, 2002 at 11:08 am
I agree use
SELECT TOP 10 * FROM LINKED_SERVER_NAME.dbname.dbo.tblTemp
will produce the same results.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 17, 2002 at 11:02 am
Since SP4 is new may want to let Microsoft know of your situation to make sure that they take a look and see if is a reporducable issue.
"Don't roll your...
July 17, 2002 at 8:42 am
Since ' (single quote) is the text delimiter in SQL you have to double up or '' when qualifiying text inside. Try
@Query = 'SELECT CustomerNo, Surname FROM tblCustomerData Where Surname...
July 17, 2002 at 8:41 am
sp_helpuser is one way you can get the roles. They come back in the GroupName section and this can be run by the public role.
"Don't roll your eyes at me....
July 17, 2002 at 8:23 am
I have not seen this before on my linked servers, however what type of server is the linked server and what si the query you are using to in the...
July 17, 2002 at 8:19 am
Look in COntrol Panel and Services at Performance Logs and Alerts and see what account the serivice is LogOnAs under. Most likely it is LocalSystem, you need to change this...
July 17, 2002 at 8:17 am
Actually you can disable it for INSERT and UPDATE which is all. To be able to drop a table, even if disabled you have to drop the FK constraint first,...
July 17, 2002 at 6:19 am
It also depends on several factors of what you are wanting to audit. If it is basic access on tables for INSERT, UPDATE, and DELETE then a trigger is sufficient....
July 17, 2002 at 6:12 am
From BOL on @@FETCH_STATUS
quote:
Returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection.
July 17, 2002 at 5:54 am
Do you have it verifing the backups? Also check to make sure the file itself is not locking or a netowkr issue that may exists. Problem with remote backups is...
July 16, 2002 at 9:19 pm
The big question to see if these meet your needs is what is the most you will lose and is this lose acceptable. If so then fine, if not then...
July 16, 2002 at 9:17 pm
The problem is like this one listed for SQL 2K SP2 see http://support.microsoft.com/default.aspx?scid=kb;en-us;Q317486 what SP level are you at with you SQL 7 server. Also someone made the statement this...
July 16, 2002 at 9:11 pm
Viewing 15 posts - 5,191 through 5,205 (of 7,429 total)