I have question regarding linking the 2 sql server. how would you created linked server on SQL 2005? can someone please help?
Hi, this should be very simple question regarding the import and export job to copy data to another table I have table and has datatypes char [source...
Hello everyone, Thanks for the refrenece and suggestion regarding Database role. I am kind of getting the logic of where to apply the db role. thanks...
Hi, Thanks for the referrence articles. I have one more question if you can answer me, I have created DAtabase role under Database and gave read and...
Hi, I have question regarding Database role. how would you create a role and how does it work as far as giving access to table, stored procedures
Let me phrase my question other way, can you CALL Function from Trigger?
Hi, Actually, I have to write a function to retreive some data and within function fire up trigger so it will update the table. This is the logic i...
Hi, I have question regarding Trigger. this would be simple question but wanted to make sure, Can you write a function inside trigger in SQL 2005?...
Hi, I have question regarding Surface Area Configuration for Features tool. It's just caused my attention and i'm checking to make sure the...
HI, I have account set up as Windows and Mixed authentication modes.
HI, I checked the following thread and made sure that my sql server has all the ports are open for client communication, added to firewall, and all...
HI, Has anyone seen the followin error in their SQL 2005 Server? The server was unable to load the SSL provider library needed to log in; the...
Hi, I had question regarding my table which has netid, last name, first name information. can someone suggest me if it's ok to set primary key on...
yes, I am using sql 2005 for my production box. The job which run is using sql 2000. thanks, I will try to run the SP_addlined sever query to my...
Hi, Here is what I do with my stored procedure.. I have production server(Server1) and I have another server which I run my sql job (SERVER2)....
Hi, I am getting an error when I run my job from one the server. The job error says that i have to run execuate sp_addlinked sever? The job which...
Hi, thanks for the replay. I max the size and it's working now.. thnks for the all help. however, i had question regarding defrag command for sql...
This is probably silly question but why do I have to type database name? shouldn't be the table name... This table has automated insert stmt. I...
Hi, I was trying to delete some record from table and I received the error message below. can someone tell me what's wrong with my database?...
thanks, I try that and it worked.. thanks for all help... i also have another question regarding defrg the sql database. I have run many updates,...
Separate names with a comma.
