Search results for query: *

Is there a stored procedure that will give me a list of all nt users. I know that the procedure 'xp_loginfo' will give me those nt accounts that are added to SQL Server but I need to get a list of all nt users in a domain.

Does anyone know how I could change the WSID of the connect string of the linked tables in my database to the current machine that is running the database? If I try to change it, it just reverts back to what it was before.

Ok, I'll try to describe what I'm trying to do. I would like to create a form in MS Access that will be a user-friendly way to add Windows NT users to SQL Server logins. I would like the end-user to be able to pick the NT USer that they wish to add using a combo box. My problem is this - how...

Ok, I'll try to describe what I'm trying to do. I would like to create a form in MS Access that will be a user-friendly way to add Windows NT users to SQL Server logins. I would like the end-user to be able to pick the NT USer that they wish to add using a combo box. My problem is this - how...

I would like to copy all user stored procedures that I have in one database into another database but they should be encrypted. Is there a way to do this without creating each stored procedure separately and inserting the 'With Encryption' clause?

Right now I have a trigger that runs each time a record in Table1 is updated. This trigger basically inserts a row into a log table that I have in a separate database. What I would like to do is only insert into that table the values of the fields that were changed. Any ideas? My current...

I have a subform and I change the sourceobject of the subform based on a tabcontrol. There is definitely something buggy because sometimes my subform is not being updated. The actual sourceobject is being changed but many times the controls have nothing in them and then when I click around...

I have a subform and I change the sourceobject of the subform based on a tabcontrol. There is definitely something buggy because sometimes my subform is not being updated. The actual sourceobject is being changed but many times the controls have nothing in them and then when I click around...

I need to get a list of all triggers in my database that have extended properties. The following statement works great but only for a specific table Select * FROM ::fn_listextendedproperty(null, 'user','dbo', 'table','tablename','trigger',default) Instead of the table name, I tried putting...

Here's the story. I have a database on one server that I want to compare to a database on another server. What I want to do is compare the extended properties of the stored procedures and also check if there are any stored procedures in the first database that aren't in the second. I got this...

When I try to delete an existing job, I get the following error: Error 14272: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX Server. Any ideas?

How do I decide whether I should be using a stored procedure or a user-defined function?

I would like to set up a linked server to another SQL server. I'm a little bit confused about what I should put for the login. I can't seem to get it to work.

What software is needed to debug SQL Server stored procedures? Can other software be used besides VB Enterprise edition?

Is there a way to show all objects that a specific role has permissions for?

Can any select statement be used with the OpenQuery funtion? I need to do a select statement on a table in my linked server called DataLineDBFs. This is what I did: select * from openquery(DatalineDBFs, 'SELECT AID, Max(Convert(SmallDateTime,[DOS])) AS LastWorked FROM Aidhrs GROUP BY AID') I...

I added a linked server to my SQLServer database. The linked server is basically a system DSN containing dbf files that are stored on the C: drive of my server. I was able to link the server and everything looks ok but then when I try to do a selection on one of the tables from the linked...

I am appending data from an Access table to an empty SQLServer table. The field names and datatypes are all the same. The primary key field is an autonumber. When I try to append the data, including the autonumber field, I get an error that it couldn't append the records because of key...

I am importing objects from one database to another database on a different server using DTS. Basically I want an exact copy of the database without the data. This works okay except that the database diagram didn't import. Is there a reason for this?

(Woops - I forgot to put a subject in my other thread so that's why it didn't have a very descriptive header.) Let's see... What I'm trying to do is create a function or stored procedure that will select all the user stored procedures in a database. I would want the procedure or function to...