Viewing 15 posts - 151 through 165 (of 168 total)
Responded to this topic though email.
November 9, 2005 at 12:20 pm
Give stuser system administrator privilege from server roles.
That will help query run without specifying owner name
November 9, 2005 at 12:14 pm
Hi Arun,
I have collected details from members here and working on it as our company is heading for 2005 setup. I have 2 server [HP DL-380] with 6 drives and based on...
November 9, 2005 at 9:53 am
Martinson,
There are different ways in which you can have output in Excel.
November 8, 2005 at 12:52 pm
Displays the number of rows, disk space reserved, and disk space used by a table in the current database, or displays the disk space reserved and...
November 7, 2005 at 3:34 pm
For the Sales database and with the said log growth it sounds obvious that number of transactions are high. In that case I will suggest having Recovery mode full, because...
November 2, 2005 at 7:45 am
Hi Asha,
I am Sql Server DBA with experience of 5 years. Currently working with a company in Georgia, previously worked with CSX Transportation,...
November 1, 2005 at 12:53 pm
Saiju,
I came out with exactly the same query that Jo Patyn has suggested. Now as it is already posted I am not posting duplication of same query again.
Still I would like...
November 1, 2005 at 12:02 pm
Hi John,
I have checked the details, and found that it is not any irregularity
but scripting creates Procedure with
EXEC dbo.sp_executesql...
October 31, 2005 at 12:50 pm
When you use Group By Clause
make sure to place all columns used in
Select Query.
In your Case column in Group By need to be separated by , not Period...
October 31, 2005 at 12:13 pm
Excellent Article.
I Like the way you explain, example helps more than 100' s of lines of description. Obviously the target audience is sql server dba/developer so it's always good not...
October 7, 2005 at 7:10 am
Viewing 15 posts - 151 through 165 (of 168 total)