You can do a find/replace on the USE, the ALTER and the CREATE statement. That will save you probably over 80% of the error messages. Add a GO + new-line...

You can see the version of the client tools (i.e. SSMS) in the "about" section of the "help" menu.

Information about the version (and latest installed servicepack) of the SQL Server...

If the law is a good point or not isn't easy to tell. I can understand both ways, but I tend to the positive way of this law. Nowadays (young?)...

Will this work for you? I created a stored procedure instead of a function.

The first part creates a (simplified) sample object and fills it with some data. The last line...

Have you already looked at this article

Tally OH! An Improved SQL 8K “CSV Splitter” Function By Jeff Moden[/url]?

From the following Microsoft connect site SSMS : Can no longer create or edit job steps I found Microsoft has fixed it:

Issue: When attempting to add a step to a...

You can use the following:

- click on "My Account"

- click on "Forums Control Panel" URL in the textline "To manage your Forum profile, please visit the Forums Control Panel"

- click...

Could the users in the restored database get their assiciated login through other AD-groups defined as LOGIN? Check the membership of the accounts in AD with the groups defined in...

double post, please reply only to Kindly resolve some error in the below...

Without the current design it's hard to provide a solid solution. But I would get to it following this approach:

Create a new table with columns to hold: the date, the...

Can you access the...

Execute the code below and see what message is stated in the 'description' column.

SELECT

sysmail_allitems.mailitem_id

, sent_status

, recipients

, subject, body

, send_request_date

, send_request_user

, sent_date

, sysmail_allitems.last_mod_date

, sysmail_event_log.event_type

, sysmail_event_log.description

FROM msdb.dbo.sysmail_allitems

LEFT OUTER JOIN msdb.dbo.sysmail_event_log

ON...

If you don't have setup any monitoring that will save the results, there is no way to investigate historic actions. You could look at the different LOG files to see...

You can't specify this permission in one statement. You need to grant this permission in each seperate (user-)database.

Set the focus to the user database and create the user (if it...

Specify the last LOG file in a new RESTORE command and use the "STANDBY = undo_file_name" option instead of the NORECOVERY. The LOG file to use can be the last...