rosshinton (2/14/2008)

For some reason when i run my asp.net code it gets to SQLConnection.open() and kicks out this error,

Directory lookup for the file "C:\Documents and Settings\Ross Hinton\My Documents\Visual Studio 2005\WebSites\uploadsite\App_Data\picturesdb.mdf"...

Can you make it as LEFT OUTER JOIN instead of LEFT JOIN ?

Hello Nabaj,

It can be done through a trigger on the underlying table or else you can code the logic in such a way that you can keep track of the...

Suji (2/13/2008)

I am facing an issue with database updates, i got a stored procedure which updates a table, this process takes about a minute to...

Hello Jeff,

Recently there was a webcast with respect to Microsoft certifications. They have clearly mentioned that the deadline for taking MCDBA exams retires in March 2009 but if a person...

Hello Ishaan,

Yes it will have a slight performance hit when you are updating rather than inserting new rows in to the high volume table. One thing you can do is...

Hello,

PSS stands for Microsoft Product Support Services.

Thanks

Hello,

You are no need to manually issue DBCC DBREINDEX when you rebuild the clustered indexes. SQL Server automatically does a rebuild of the non-clustered indexes whenever the clustered indexes are...

Hello Vika,

You can refer to BOL at this link

http://msdn2.microsoft.com/en-us/library/ms190307.aspx

It is simple to use database mail as said by earlier member.

Thanks

Hello Loner,

Yes it is available in SQL 2005 and it is working.

You can't directly query the mirror database but in fact you need to create a snapshot of the mirror...

Hello Kerry,

Make sure when you restore the full backup copy, it should be restored by keeping the database in "NO RECOVERY" mode. It should be in "Recovery" mode when you...

Hello Rav,

Have you checked whether the file created by you is accessible by the SSIS connection credentials?

Does the SSIS connection has access privileges to the shared / network location?

Hope this...

Hello,

Is "ibrowse" the domain name??

If it is a domain name then it will be present in your Active Directory (machine) database. Normally, system admins set such type of service...

Hello Matthew,

As conveyed by Toni, you can use the "DateAdd" function to return the next month same date and there is a catch for which you need to write some...

Hello Dan,

I'm able to execute the query other than "master" database without any errors.

Please check once at your end.

Thanks