Viewing 15 posts - 11,341 through 11,355 (of 14,953 total)
All of which are why I suggest a trace.
And don't worry too much about a server-side trace (the kind I'm talking about) taking a lot of server resources and slowing...
January 23, 2009 at 2:36 pm
Glad I could help.
January 23, 2009 at 2:33 pm
In my opinion, the negatives for SQL Server are far outweighed by the positive aspects. It's simply that perfection is unattainable, so taking something great, you can always find...
January 23, 2009 at 2:32 pm
Have you thought about using replication, and setting up SQL Express on the laptops? It's going to be easier than constantly creating and synching Access databases.
If you have to...
January 23, 2009 at 2:27 pm
Yeah, it was something in that range. I don't have access to that database any more (since it was for a company that no longer exists), but it was...
January 23, 2009 at 2:24 pm
Since it's timing out on the login, I suspect that it's not being passed a password and/or username, and it expects one. Might need to be part of your...
January 23, 2009 at 2:21 pm
The first thing that comes to mind is why select from the target table joined to "inserted", when you can just select from "inserted"?
The next thing is that you could...
January 23, 2009 at 2:19 pm
It generally won't do 20 scans in that case. The optimizer is usually smart enough to figure out that one scan will do it. The only times I've...
January 23, 2009 at 2:02 pm
Have to agree with you on that Joe. Just want to be sure that people who follow standards understand that doing so will not be a panacea, and will...
January 23, 2009 at 1:59 pm
Don't run profiler for the traces. Create them separately. Search for "trace" in Books Online, and it will come up with "Introducing SQL Trace". Specifically, you're going...
January 23, 2009 at 1:56 pm
To clarify:
I set the output to Text, created a couple of triggers, and ran the query. Here's what I got:
create trigger Numbers_NoDel on dbo.Numbers
instead of delete
as
rollback;
go
create trigger Numbers_NoUpd on...
January 23, 2009 at 1:47 pm
If you want one file per trigger, you can do that from scripting the database. Right-click on the database in Management Studio, select Tasks, Generate Scripts, and then pick...
January 23, 2009 at 1:43 pm
bbaley (1/23/2009)
Since we were talking about logic on the application side vs. logic on the db side...
seems I always end up in some...
January 23, 2009 at 1:40 pm
There's a Copy Files and Folders option on that. Just use that. It's pretty straightforward.
January 23, 2009 at 1:36 pm
How about something like:
select definition
from sys.sql_modules
inner join sys.triggers
on sql_modules.object_id = triggers.object_id
Does that give you what you need?
January 23, 2009 at 1:33 pm
Viewing 15 posts - 11,341 through 11,355 (of 14,953 total)