Viewing 15 posts - 9,616 through 9,630 (of 9,630 total)
I have seen this problem as well. The issue could be that your NT login does not have rights on the SQL server or database or the SQL Server is...
February 24, 2004 at 7:32 am
SQL Server will not use an index on a (LIKE '%query') filter so you might want to reconsider this type of query.
February 23, 2004 at 9:03 am
Base don what I see so far, for your first time through you are going to execute your code in the IF's. After executing you need to Set @last_acctno =...
February 16, 2004 at 11:25 am
YOU can also place Print or Select statements in your trigger(s) to determine if or where the trigger(s) are firing and failing.
February 12, 2004 at 6:55 am
Alerts emailed to an Operator include the Server Name. So I wouold use one account.
February 12, 2004 at 6:48 am
Not being a web developer I cannot be sure what the issue is. One thing you can check in SQL Server is if the database Auto Close option is on. ...
February 12, 2004 at 6:43 am
Finance is being unrealistic. If they expect IT to offer any support then at least on IT person has to have Admin access to the server and to the database. ...
February 11, 2004 at 8:18 am
First I would try to determine WHY the database is being marked as suspect. Here are a couple of reasons we have had the problem at my office:
You have a...
February 10, 2004 at 6:32 am
I am a fan of using Identity columns as primary key and then if appropriate using the "natural" key as unique clustered index. Since the promary key is what should...
February 6, 2004 at 3:50 pm
If you are using SQL 2K you may want to examine using a table returning or inline user-defined function. You can almost look at these like a parameterized view. It...
February 6, 2004 at 3:27 pm
The correct way to call xp_sendmail using T-Sql is:
The use keyword in T-Sql is to change the database context in which you are working. YOu cannot do that...
February 6, 2004 at 3:23 pm
Cross Database ownershp chaining works, but you have to remember that enabling that means it works all the time. SO if you have tables you do not want to have...
February 6, 2004 at 7:44 am
I agree with the other posts. Unless someone can tell me what hte Windows Application Application Log is I would have to say that the Windows APplication Event Log +...
February 5, 2004 at 7:30 am
While I have not implemented partitioned views in porduction I have done some experimenting with them. I believe that if you are using an Identity field in your tables that...
February 4, 2004 at 8:49 am