RE: How to locate a client with fake hostname

By the way, I should note that W2K (probably XP) includes a network sniffer that's decent (limited to what comes in/out of that server, not a general sniffer). So you can do some gross things like sniff all packets and then search out strings or check specific connections to determine which did what. But that's […]

RE: Update trigger on a specific column...problem

Uday, first of all, your second part does not take a set based update into account. This might give you some problems if more than one device is updated in one statement. For the rest, you should not use the syntax you're using. Try the following for the if statement : IF EXISTS (SELECT DEVICE_STATE […]

Your payroll staff are members of the database...

RE: Creating a PDF from a Stored Procedure

Where do you find the specs for the PDF format? I would also like to make a suggestion. I personally think that code that is shared with others should be easier to follow. One of the things that helps with that a lot is clear variable names. I have no idea what @cr, @pr, or […]

RE: Comparing two tables

Check out the script I submitted: "Compare Parallel Data Streams". It is designed to find the diferences between two parallel data streams, i.e. QA and production to verify a new process. Nate

RE: Replication Document

Hi Andy, Transactional type is working fine for me, where ever i update source , snapshot agent is updating subscriber, But if i create any tables/objects how this will reflect in subscriber, what Replication type i need to use. This is first time I am doing replication. venkatesh

RE: Export to Excel without DTS. Possible?

quote: I am trying to figure out how to export the results of a query to Excel with some specific formatting. Is this possible to do without using DTS? One method could be -- Inputs:File name of the excel document. -- Returns:The query result, written directly in Excel document! DECLARE @err_desc varchar(255) DECLARE @i int […]

SQL Server Security: Pros and Cons of Application Roles

Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.

RE: Newbie: continuing backup failures

In Enterprise Manager-SQL Server Agent-Jobs look at the specific jobs that failed. Right click and check the job history. Also check the SQL Server logs as well as the maintenance plan history. Somewhere in all this there might be more informative error messages. Try posting all of them here so that we have more to […]

Which of these steps is not required to...