With SQL Server 2005 the service accounts just needs to be a standard domain account. When you install SQL Server and specify the domain account (or when you change...

You may be able to use the COLUMNS_UPDATED() function to determine which column(s) have been updated. Check out BOL for details.

As Gail has already mentioned you would be better...

I believe Microsoft Operations Manager (MOM) can do this. You could also write a custom service in .NET that uses WMI to monitor services and/or the windows event log...

I would say that I do a combination of learning through training and experience with an emphasis on experience. People who know me would find this hard to believe,...

If a SQL function is setting the value to null you should see that happening. Really the best thing is to identify the offending code and use isnull or...

If you already know you are passing "" to SQL Server then you won't learn anything using Profiler. The version of the .NET framework installed on the IIS Server...

NuJoizey (7/17/2008)

---

yes there are a few ways to get who the user is, but when I moved over the app the current way the app is using stopped working. ...

I agree with GSquared. The only way to accurately do this is by using a calendar table. You could so a lot of logic using DateDiff and get...

The TextData column in the trace/profiler will have the exact sql statement(s) that have run. If you export the results to a table and then you can check the...

MVJ is correct in that DataLength returns to storage bytes so unicode will return 2 bytes per character. So you do need to know the data type in order...

In order to get rdlc files you need to be in a .NET project, not a reporting services project. You do add new item and select report. Then...

You would want events from the stored procedures and T-SQL event classes. If you use SP:StmtCompleted and SQL:StmtCompleted you can filter on ObjectID and should get what you want.

In VS 2005 you can go to Help->About and it lists the different products installed and by selecting Reporting Services it tells you the version. SQL 2000 is 8.*...

I would handle it by specifying the column list in the procedure and aliasing the column names so I had the same list. If there are a different number...

Thanks for posting your solution.