it's possible, but let me explain the pitfalls.

once i have a username and password with access to a database, i can use any application to get there...SSMS, a program i...

for me, the master database doesn't have anything of interest besides logins;

i would restore a master database as a user db so i could extract logins, if they were...

Without looking at your trigger, I'm thinking there may be a better or faster way to do whatever you are doing in your trigger;

if your trigger...

the database engine and a lot of the support files must be installed on the %system% drive; after installation, you can move all the mdf/ldf files(alter database with move )...

well, what is the name of the table inside the foxpro database? is it dirmsarf,...

yes that was what i was refering to, i could/should have been more precise, sorry;

with a COUNT, the OutputList has no values, select a field instead to see stuff in...

believe it or not, NOT declaring objects with 4 part naming actually increases the overhead, admittedly by a very very tiny bit; The SQL Engine has to lookup (or infer)...

Mr.SQL DBA (8/31/2010)

---

Hi SSC Experts,

From the front end application a numeric value of 10 digits with datatype varchar(max) ex:9247497829 like Phone Number

is entered by the front end user and is...

you might be able to add a job which checks for new entries in the view on an hourly basis or something, and have that job insert the new data;

but...

BOL examples show that after the connection info, you need the table to extrac t from, outside fo the parenthesis, and it appears to need 4 part naming conventions;

here'sa BOL...

don't forget the LIKE operator can take some quasi regular expression commands to help determint ehte list:

--every proc/view/table that DOES NOT contain a number.

select * from sys.objects where name like...

i think the rule is this:

if the calling user is NOT a sysadmin, then the proxy account is used.

if the calling user is a sysadmin, then the account being used...

robert i'm pretty sure you have some third party object that is reformatting your SQL;

by default, SSMS is just a syntax-highlighting text editor, with no auto-reformatting as far as...

a parameter cannot be assigned inside the calling statement; just break it up into two lines::

SET @DB = DB_NAME();

EXEC DB1.dbo.test @DB

remember the purpose of the clustered index is to make it faster to find the data; the data does nto necessarily have to be non-unique and not auto-increasing;

does your...