Hello,

You can use this format. Run this statement in Query Analyzer

select convert(varchar(12), getdate(), 101)

Hope this helps.

Thanks

Hello Shine,

You can go to this site and look for the latest version service packs and hotfix. If you click on the hyperlink you will be routed to the Microsoft...

Hello Jeff / David,

Thanks for your inputs. As indicated in my post let us hope that there is no primary key on the table. Also I can write the logic...

Hey Ravi,

It was too cool to dig out the puzzle words this Friday morning. This way it will allow us to memorize the words which we normally speak in our...

Hello Jez,

It is very clear that you are opening the transaction on one machine and then passing on the pointer to do some operations on another server where there is...

Hello,

I think you can use the undocumented stored procedure which is available in SQL 2000 i.e., sp_msforeachdb

Look for the syntax and other options by google search

execute this statement from one...

Hello,

The simpleest way to have the user do all the required is to create a user role, bind this role with the required level fixed server role permissions and then...

Hello,

I'm also trying to pick up on SSIS front and during my search came up with this tutorial link

http://www.developerdotstar.com/community/node/364

Hope this might help you and your team.

Thanks

Hello Simon,

Our users used to get this error occasionally when they connect to our development environments and the reason found is that the password policy expires every 30 days. These...

Hello x-portal,

Under what account the SQL services are running?

Does the SQL account have permissions to access the folder where the file exists?

First try by placing a .txt file with some...

Hello PostIT,

This is a common factor that the database increases its size as soon as data is inserted. You are talking here about the images which takes lots of space...

Hello Peers,

I would appreciate any solution to the issue I'm facing.

TIA

Hello Sag,

You need to attach the AdventureWorks databases just like the way you attach user database files copied from one server to another. By default it will write the database...

Hello Smith,

It would be wise if you wait until you get a job in that line and gain some exposure before you attempt for the admin exams. As you said...

You can use sp_who stored procedure to return the details required.

Thanks