Well you have two things going on here. First...

Please take a few minutes and read the first article in my signature for best practices when posting questions.

rayh 98086 (12/3/2013)

---

Hi,

I would like to get the results of three different queries and put them all into one temp table. I am trying as follows but does not...

river1 (12/3/2013)

---

Hi,

I have a table and I'm doing a truncate table to that objects. The table has one key (two columns).

It seems that data is not always truncated.

Should I expect...

Yes you can do this from a form for sure. I suspect you could just as easily...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1519356-391-1.aspx

Laura_SqlNovice (12/3/2013)

---

Hi Guys,

I need to execute sql server proc from MS Access or Excel... the proc has couple of parameters, but do not have any data comming out. Can we...

Excellent!!! Glad you got it working.

Grace09 (12/3/2013)

---

I have a trigger on a table, the trigger delete records from another table. I need to grant a permission to a user who can turn on/off the trigger....

Ananth@Sql (12/3/2013)

---

Dear Sean

I am not new here, this is my friend's problem.I am bit curious.so considered all these i just...

sharonsql2013 (12/3/2013)

---

I need to display a bunch of data for a single category.

Category - IT and Hardware

Configuration_Items - Servernames approx 6000

I do not understand what char type should I use...

Ananth@Sql (12/3/2013)

---

Hi Polks,

;With Cte

as

(

--- some joining query here with 3 tables

--first table has 30 crores records,second one has 6 crores ,third one has 791 records

)

select * from cte

--The...

raysteve43 (12/3/2013)

---

We have a large lookup table with 200k records. This table is used frequently in a high volume database. We now have to update that...

Permissions are not granted to a trigger. They are granted to a...

steve.jacobs (12/3/2013)

---

rmunwin (12/2/2013)

---

I could be wrong but if you pop the server into single user mode and an index that uses a as a lead column will return results in...