Viewing 15 posts - 841 through 855 (of 1,315 total)
If you have text in red (which means it is a quoted string) that looks like T-SQL code, the stored procedures are probably using dynamic SQL. This means they are...
April 21, 2006 at 8:37 am
Apparently you could set up a trace table in SQL Server 7.0 using xp_trace_addnewqueue, but not in SQL 2000 with sp_trace_create. I don't know how Profiler does it. Maybe you...
April 21, 2006 at 7:55 am
I've never tried this, but a quick search on MSDN for "SQL Server 2000 login auditing" turned up a lot of links, including this article that discusses enabling C2 auditing...
April 20, 2006 at 7:54 am
Using FULL JOIN will include rows where the join field is NULL, but they will be in different records. Assuming tables A and B are joined on field XYZ and...
April 19, 2006 at 10:02 am
Another good condition for the WHERE clause would be "and hostname <> @@servername" to be extra careful not to kill a server process or scheduled job.
This assumes users can't just...
April 19, 2006 at 8:57 am
Look at the program_name field in the results of sp_who2. You will see "SQL Query Analyzer", "SQL Query Analyzer - Object Browser", "MS SQLEM", and/or "Microsoft SQL Server Management Studio"...
April 19, 2006 at 8:50 am
There has to be a login available for the application to connect to the server, and it has to have access to a database, before it can use an application...
April 18, 2006 at 6:40 pm
You can script the stored procedures to a file, then back that up.
Right-click on a database in Enterprise Manager or Management Studio and look for "Generate Scripts...". Use the formatting...
April 18, 2006 at 5:33 pm
I may have heard of it on talk radio, or on the internet, about two years ago. The people behind it started working on it about 20 years ago, and have done...
April 18, 2006 at 5:23 pm
Your entire paycheck is part of a company's cost of doing business, but the FICA matching contribution is part of their labor budget so the easiest thing to do might...
April 18, 2006 at 2:47 pm
I was able to reproduce this behavior in Enterprise Manager, but not with Query Analyzer's Object Browser or in SQL 2005 Management Studio. I am guessing that the SQL-DMO code...
April 18, 2006 at 2:33 pm
You are correct, sqlmaint uses DBCC DBREINDEX.
I believe it was DBCC REINDEX up to version 7.0, then renamed DBREINDEX in SQL 2000. In SQL 2005 it's ALTER INDEX (although DBCC...
April 18, 2006 at 12:53 pm
In addition to the argument over where business logic belongs, there is the issue of security.
Data can be secured easily if all access is through views and stored procedures (i.e....
April 18, 2006 at 12:35 pm
Viewing 15 posts - 841 through 855 (of 1,315 total)