You can also try to use Profiler.

Choose Stored procedures:completed and TSQL:BatchCompleted events, select TextData, Reads, Writes columns. Save trace to a table. When you will finish tracing, you can query...

The best way to debug function is to convert it to regular TSQL script. Comment -- create function, return, etc. Convert input parameters to variables - declare them. Run statements...

There is good salary survey in December 2005 issue of SQL Server magazine. They provide very comprehensive analysis by location, title, experience, by age, etc.

I would recommend you couple of tools:

1. You won't spend a penny for it. It is SQL Server diagrammer, in SSMS go to your database then click on Database Diagrams...

Hi Dinakar,

It's a good thing to do some research on a company prior to sending them resume. I do not know how it is in other parts of the world,...

Hi Yelena,

Thanks for pointing to this file, I found it in my path. However I did not find any references to the server names, I opened this file in Notepad...

Thanks David and Jamie for your help.

I tested both methods and decided to re-create destination SQL Server table with nvarchar fields data-type (as opposed to varchar). Now it works fine.

Thanks,

Mark

grant

create procedure to role_name

revoke create table

sqlcmd is a new version of osql for 2005. osql is also supported for backward compatibility. As I mentioned before, you can use osql and in my case it worked...

Try this:

sqlcmd -d msdb -Q "execute sp_start_job 'job_name'" -S server_name -E

I also used osql instead of sqlcmd, works exactly the same.

I can recommend you two books for this:

1. Michael Otey. SQL Server 2005 New Features. McGrowHill Osborne. It is mostly summary describing each new feature.It is good jump-start if you...

Thanks to all for your responses and tips.

The reason why I rarely run DBCC UPDATEUSAGE is because it takes about an hour to run - ut is very large table,...

Thanks for Save Change Script tip, I did not know about this.

But this is not exactly whah I want. The script that it generates shows "create table ..." without identity...

The reason why I want this hint is I suspect that we don't really need any indexes on this particular table (or maybe we don't need them for certain values...