Viewing 15 posts - 166 through 180 (of 628 total)
In T-SQL the connection is handled entirely by the Query window you open. Unless you specify a database name in the Query then you can run the query against either...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 14, 2011 at 8:31 am
I think it might be getting confused try adding an alias for the tables like so.
select COUNT (empl.employee_no) as 'Number of Employees in Section',dep.Department_Name
from Employees empl
INNER JOIN
Departments dep
on dep.Department_No=empl.Department_No
having
COUNT(*)...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 14, 2011 at 7:17 am
What happens when you run it?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 14, 2011 at 7:11 am
I don't know so much as information to provide as much as things to consider. What else is running on the server? Who is connected to the server?...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 13, 2011 at 2:38 pm
Thank you Michael. This is one of my must have scripts for a DBA toolbox very well done.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 13, 2011 at 1:58 pm
Llike other languages you can not bypass a compile error with a catch block. Since the insert does not match the table definition this is generating a compile error...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 13, 2011 at 12:59 pm
I did not write this but here is a little script I picked up a while back that I use. It provides some pretty useful information. I would give...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 13, 2011 at 12:44 pm
Grant Fritchey (4/13/2011)
ChrisM@home (4/13/2011)
CirquedeSQLeil (4/13/2011)
Grant Fritchey (4/13/2011)
Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.*cough*
That should help.
Don't you have to...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 13, 2011 at 12:17 pm
A little link to lead you in the right path.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61409
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 13, 2011 at 12:16 pm
Daniel Bowlin (4/13/2011)
crookj (4/13/2011)
sing4you (4/13/2011)
crookj (4/13/2011)
Speeking of older music....Anyone remember Harpers Bizarre?
Joe
I do sort of remember them. What were their hits?
Pocket full of miracles, anything goes, and Feeling Groovy...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 13, 2011 at 11:54 am
Seeing as how in the grand state of IL I have an extremly low chance of actually encountering one I can say I have never given thought to weather I...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 13, 2011 at 9:54 am
We you setup the connection in the package if you specify widows autentication then know. The person using the package or again the Agent account if you are running...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 13, 2011 at 9:31 am
I could be horribly wrong as I have not done extensive research on GUID's but I do not beleive that would be the case. The GUID is generated per...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 12, 2011 at 2:45 pm
I do not beleive that would show what you are looking for. Even if the child record existed in table 2 I would not expect to find a relationship in...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 12, 2011 at 2:35 pm
When I create a database I am always logged in as my Windows Authenticated logic which places me as part of the SysAdmin group.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 12, 2011 at 2:11 pm
Viewing 15 posts - 166 through 180 (of 628 total)