Hello again,

Apologies for not being clearer with my first post.

There is an option in Query Analyser that, by default, truncates the number of characters returned to the User Interface.

You...

Hello,

Are you using SQL Server 7 and are you creating the table via a Select Into statement? If so, may be this article answers your question:-

http://www.sql-server-performance.com/articles/per/avoid_bottlenecks_locking_tempdb_p1.aspx

Regards,

John Marsh

Hello,

The truncation is probably being caused by a setting in Query Analyser. Try changing it via Tools, Options, Results, Max Characters Per Column.

Regards,

John Marsh

Hello,

Did you already see the following MS KB article:-

http://support.microsoft.com/kb/232580

Regards,

John Marsh

Hello,

A couple of questions: Do you have a particular reason to include the ID columns in the Unique Constraints? I ask, as the ID columns are Identity columns, so will...

Hello again,

I would suggest taking a look at a few of the SP related help topics in SQL Server Books Online, to get at least a basic understanding. For example:...

Hello Sylvia,

If you are waiting 10 to 30 minutes for each test execution to complete, then why not make your improved Dev environment a short term goal i.e. invest the...

Hello,

I would say it is possible to write an SP to perform the logic you require, and an SQL Agent Job can be set to execute every five minutes.

What specifically...

Hello,

I suspect that the important thing to notice from the KB Article provided by Pablo Berzukov is that, by default, Named Instances listen on Dynamic Ports.

I guess nobody has changed...

Hello,

Do you have SSMS (SQL Server Management Studio) installed on the Database Server? If so you can execute your SQL Statement from a Query Window within SSMS. You can also...

Hello,

Sorry to answer a question with a question (well, actually two and a half questions), but:-

1) Can there be multiple occurrences of the value of Col3 for the same value...

Hello,

It’s not an error message that I have experienced myself, but there are a couple of threads around that suggest it can be caused by having the “FIPS compliant algorithms...

Anyway, it is good to hear that is working now 🙂

Best regards,

John Marsh

Hello again,

I agree with Brandie Tarvin – the problem is outside of SQL Server. Are you responsible for the Mail Server? If not then ask the Administrator to check the...

Hello Mahesh,

I guess you are planning to use msdb.dbo.sp_start_job to immediately execute a Job from an SP – correct?

In which case, I presume you have read through the Permissions section...