jvisagl (2/29/2008)

---

Thanks for your response.

1)Yes

2)BID

3)Yes

I figure out how to do it. I used the wizard and this save a copy. But now I am trying to understand how this works....

Glad we could be of help. The datareader should be faster when only accessing data and should be less resource intensive.

Autoclose is designed so SQL Server will return resources to the system and the default is off. It should never be on for any application used on a daily...

I'm not sure what you mean by "assign a string to a column name". Do you mean you want to dynamically select the columns based on a parameter? ...

Even for an expected 50-100 records cursors are very inefficient when compared to set-based code. It is not just long-running queries that need to be fixed it is also...

As I was typing that post I thought, can you disable DDL triggers? If not would the DDL trigger catch a disable trigger statement? Unfortunately there is always...

I generally have not had to worry about people modifying columns because I never, grant direct modify permissions to a table, I actually rarely grant select on tables. Everything...

It's not that you are bothering me, but you need to use the resources you have and BOL is a good resource. That should be the 1st place you...

Ever heard of Books on Line. You look there for sp_add_jobstep and it gives you all the parameters that go with and their usage.

The parameter is @step_id and you...

I would actually run the CheckPoint command and let SQL Server take care of itself. I posted this on your other post about the tempdb problem.

Running DBCC...

From BOL:

CHECKSUM satisfies the properties of a hash function: CHECKSUM applied over any two lists of expressions returns the same value if the corresponding elements of the two lists have...

Check out BOL for Dynamic Management Views. There is one called sys.dm_exec_connections that has user connections. There are many others that may have information you want as well.

Check out this forum: http://www.sqlservercentral.com/Forums/Topic460230-8-1.aspx#bm460247

Is the database set to Autoclose?

Exec sp_dboption 'dbname', 'autoclose'

Will tell you.

Exec sp_dboption 'dbname', 'autoclose', 'off'

Will turn it off if it is on.

I don't know of any stats on this, but I have always wondered why encrypt at the SQL Server? This means that the data is now unencrypted on the...