Hi,

By default Express editions uses the SQLExpress for the instance name.

So you can not install the SQL2008 with the same instance name where a SQL2K5 Express edition installed.

But what...

Hello Paul,

I'm sorry you thought that to be spam.

Because I gave the name of a tool that I downloaded, tried and found useful for backing up a SQL database with...

Hello,

FS property is actually fits very well with your backup including files on file system.

But I do not know how it works with log shipping, replication, etc.

But I can suggest...

Hi dheer,

You can try the following select query and if it works for you, you can include it in a simple function

SELECT 1 + ( DATEDIFF(mm, 0, @d2) - DATEDIFF(mm,...

Hi subha,

What is the error message, etc you get when you execute the query?

And what is the SQL version, perhaps you should use sysobjects instead of sys.tables

Eralper

http://www.kodyaz.com

Hi Dave and Paul,

So do you think it is better to use only NEWID() function?

Although using CheckSum() might result with a fine distribution of numbers.

Fabricio is right, his suggestion works for me also.

With one difference that I was only using the syscomments table not joining to sysobjects in order to get a better output.

Unfortunately...

I have seen on some web sites suggesting to use ORDER BY CHECKSUM(NEWID()) instead of using only NEWID() function.

I think it affects the seed of the NewId function to create...

Hi Subha,

You can run the below select query as a sample.

This will check all databases on the related instance for a specific table name

EXEC sp_Msforeachdb "use [?];select '[?]' dbname,* from...

I have taken 70-452 BI exam. What I remember from that exam was it was far more easier when compared with SQL2005 BI exams.

I think if you work on BI...

Hello David,

Besides working from SQL books do not forget to make hands on works on SQL2008.

I have passed this exam when it was in beta period, but then I was...

So what is next Sunny?

Do you have plans for an other exam?

Yes Web Query exists in Excel2003 too.

I have just made a sample query.

But is there a way that I can get the code running behind?

Thanks for the link, great!

Some MS Office components are so powerful that there is not a matching utility in SQL Server.

I experienced such a situation on SSRS once. The graph...

Hello Skull,

Do you have a reference link for a sample?

I know that Excel2007 has many functionalities like data mining components, etc but I did not hear about getting data from...