Viewing 15 posts - 1,966 through 1,980 (of 3,221 total)
Hawkeye_DBA
Users can connect just fine, and most of the time they do not have issues.
How, through what program are the users connecting? SSMS / Web application or?
April 14, 2010 at 4:11 pm
mike 97607
You might want to read these 2 articles, starting with Jeff Moden's
http://www.sqlservercentral.com/articles/T-SQL/68467/
and then going on to Lynn Pettis's article
http://www.sqlservercentral.com/articles/T-SQL/65522/
Both are excellent explanations and contain sample code. Combined, these...
April 14, 2010 at 10:03 am
This answer my question#2.
Hello. I have some store procedure and some trigger that update the table.
These 2 questions you have not answered
1. The purpose of gathering this information?
3. Are you...
April 13, 2010 at 4:43 pm
If you elect to follow Steve's forume posting (above this one)
use this link to watch a video that shows you how to use the sp_Sp_MSforeachtable undoucumented procedure
Using SP_MSForEachDB and SP_MSForEachTable...
April 13, 2010 at 2:40 pm
I would suggest you use Technet
http://technet.microsoft.com/en-us/default.aspx
and search for "sql server odbc connection" and then further refine the seach to "SQL 2005".
April 13, 2010 at 11:12 am
rcruben
Hello. is possible to get the store procedure name from trigger when a update operation was performed?
May I ask:
1. The purpose of gathering this information?
2. Is all...
April 13, 2010 at 9:14 am
I would strongly suggest you read this article by Jeff Moden and see if it is applicable to your situation
April 13, 2010 at 8:25 am
Need a little more information in order to even start assisting you.
Is it a single dimension array or a multiple dimension array?
Also .. some sample data (Items) the array will...
April 13, 2010 at 7:51 am
Using Books On Line
Lool at the ISNULL function:
ISNULL ( check_expression , replacement_value )
check_expression
Is the expression to be checked for NULL. check_expression can be of any type.
replacement_value
Is the...
April 13, 2010 at 6:14 am
Suggest that you go to
http://technet.microsoft.com/en-us/default.aspx and in the search window input "SQL Server 2008 new features"
April 12, 2010 at 12:16 pm
To add emphasis to Paul White's comment:
I have to say though, that this is usually a poor design idea - storing more than one attribute in a single column using...
April 12, 2010 at 6:49 am
Is this something even remotely like you need?
CREATE TABLE #bitwise
( a_int_value int NOT NULL,
Hours INT NOT NULL);
INSERT #bitwise --VALUES (1);
SELECT 1,8 UNION ALL --Prime shift
SELECT 2,6 UNION...
April 11, 2010 at 6:51 pm
Steve Jones - Editor (4/10/2010)
Chores.
Done - RELAXING
April 10, 2010 at 12:57 pm
Having said what I said in my post above and having some free time ... will this be what you want?
Note you have not defined what you consider the...
April 10, 2010 at 12:45 pm
If you would provide the table definition ... some sample data, required results formatted as described in the first link in my signature block you will vastly increase your...
April 10, 2010 at 11:56 am
Viewing 15 posts - 1,966 through 1,980 (of 3,221 total)