Hi,

if you search this site with the keywords Table Rowcount you will find a lot of discussions with queries and some scripts. I have the following one for rowcont with...

Steve,

In addition to the test environment you have to have a tested roll-back plan or I would say, Exit Strategy. I had 2 cases when the upgrades were running great...

Data,

I did resolve the issue for one of our developers and he is using this syntax in his jobs. You may test it from the command line first as opening command...

I looked up the solution that Brian Kelly found last year answering to my question on the same topic:

SELECT OBJECT_DEFINITION(<object ID>)

As an example:

SELECT OBJECT_DEFINITION(OBJECT_ID('sys.sp_help'))

I tested his solution and added a comment...

Hello Oliver,

did you get any error messages?

There are 2 things to try:

1. On the screen with the table list click on each table and click Preview button. If the table...

Oliver,

How did you do the import?

sp_helptext [ @objname = ] 'name' [ , [ @columnname = ] computed_column_name ]

Michael,

you can not just re-create, I assume. Jobs are different, some run Maintenance Plans, some run DTS packages. For the miantenance Plan we found out that "Delete Files Older Than...

Hello,

the backup size is more or less the size of the data. The database size may be much bigger with a lot of extra space in the database. I did...

Also sometimes the backup is from another server with different drive structure and we have to correct the drive letter or path in the Physical Path for the files. The...

I am taking the Fifth.

Do we need this port to develop / run packages? I answered correctly  but the reference says we need this port to start/stop the service. I wonder if we need...

You do need sysjobs and sysjobschedules to determine a scheduled time. You probably don't need to use Event Log, use sysjobhistory table to check if the job was executed for...

Paul,

did you specify in parameters

@message = 'my message string goes here'

Yes, you should close connections if you don't need them anymore.There is an overhead when esteblishing a new connection so close your connection only when the task for this connection...