NuJoizey (7/16/2008)

---

thanks jack, but they are still on the same server, just a different server than before. I'm sorry if I wasn't clear - And I just verified that...

Almost everything in SSIS takes place in memory on the machine the package is running on. If you are running your package as a single transaction then the database...

Scott Duncan (7/16/2008)

---

Run the following command from a query window:

[font="Courier New"]SELECT * FROM ::fn_trace_getinfo(0)[/font]

This will return details for all traces running on your system....

There is some additional work that needs to be done in order to get ASP.NET to pass Windows credentials to SQL Server when on separate servers. It works fine...

From Inside SQL Server 2000 you can use select * from :: fn_trace_getinfo(default) which returns information on all active traces.

Were the database and web site originally on one server? Are you using a generic account for login to the database or windows authentication?

Look in BOL under deprecated features. This does not give a list of everything like *= outer joins because that is included under compatibility versions. You can also...

BOL is always a good place to start. Here is an article from this site that is from SQL 2000, but the concepts and process are basically the same...

shahbaz.oradba (7/14/2008)

---

Hi,

how can we know that particular query is taking long time and we have to optimize that,and i heared that query optimization through sqlserver profiler degrades the perfomance.?

what is...

You can create a new data file, then you need to move existing tables or indexes to the file as only new tables would be created there otherwise.

DKG (7/16/2008)

---

isn’t it a good idea to create a role instead of give permission on each object, because if another user comes with the same requirement, i m goona add...

Sorry, it's been a while since I have managed security and I sent you to the wrong place. On the Home page, click on the Properties tab and click...

You can query the INFORMATION_SCHEMA.COLUMNS view like this:

[font="Courier New"]SELECT

            TABLE_CATALOG,

            TABLE_SCHEMA,

            TABLE_NAME,

            COLUMN_NAME

    FROM

            INFORMATION_SCHEMA.COLUMNS

    WHERE

            COLUMN_NAME = 'SSN'[/font]

Yes there is a Like. You also need to match case so you should use a .ToUpper() when matching strings.

You need to give the users rights to the report server. You can do this using report manager or SSMS. In report manager you need to go to...