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...
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
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, 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...
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, 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?...
I am trying to restrict the log size of my database but i am getting an error. "Size is greater than MAXSIZE"..(sql5040) error". how do i go by to...
HI, I have question regarding the sql 2005 server. I have database on the server which are set to simple recovery mode option since we don't have any...
Separate names with a comma.
