Yes.

What problem are you having with the datatype? Is this related to your other post in this forum?

Can you post your Data Definition Language and maybe a query or two that you've tried? That would help folks be able to help you troubleshoot.

Is there the possibility of you posting the code? There may be a way to eliminate the cursor. That would allow your stored procedure to execute recursively as a...

Ward Pond addresses this issue in a recent blog post.

Database Programming: Slaying The Time Zone Conversion Beast (or at least rendering it comatose)

You may take a...

xp_sendmail in and of itself isn't going to do this. It'll interface with the Outlook client, but to my knowledge, there's no direct way to flag a message to out...

It's supposed to be a notification services forum, however, since it also has a title of Administration, people post non-notification services questions here, too. As a general rule, posts don't...

Stored procedures are physically stored in the database itself. Therefore, wherever your database files are, there, too. You can find the location of these files by using sp_helpdb if you...

If you're doing a real time copy, then the methods above are your best options. The query given with the lock hint (NOLOCK) prevents your SELECT query from establishing (or...

Probably the best way is through a script outside of SQL Server as there are WMI mechanisms to handle services. However, there is an undocumented stored procedure, xp_servicecontrol, which can...

I agree. The primary key is there to ensure each row is unique within the table. By default SQL Server will create a primary key as a clustered index, but...

How are you handling the active/active situation? Synchronous connections between the two SAN storage devices?

It only runs local to the SQL Server. Which means if the SQL Server service is in stopped or paused mode, you can't execute a T-SQL query against it remotely....

You can only have one clustered index because that's the way the data is physically sorted. Non-clustered indexes reference the clustered index, if one is created, which is why you...

The clustered or non-clustered part tells SQL Server what type of index you want to create for that primary key. A clustered index means the data is physically sorted based...