Monthly Archives: January 2010

The backup set holds a backup of a database other than the existing database

I was trying to restore database using T-SQL and I ended up with error message “Msg 3154, Level 16, State 4, Line 1 The backup set holds a backup of a database other than the existing ‘GlobalObjects’ database.”. Sometimes I

Posted in Microsoft Technology Tagged with:

Web Services in SQL Server 2005

I was looking into how we can create a web service in sql server rather than traditional way (using IIS in .net). I found the good article. Here is the link. http://davidhayden.com/blog/dave/archive/2006/03/30/2896.aspx Another interesting topic is how stored procedure can

Posted in Microsoft Technology Tagged with: ,

SQL Server Management Studio – Hangs forever while connecting local/remote server

I am having the problem connecting the local as well as remote server using SQL Server management studio 2005. I just enter the server name, Login , password and hit the connect button, It just hangs forever and I am

Posted in Microsoft Technology Tagged with:

Difference between IDENT_CURRENT, @@IDENTITY,SCOPE_IDENTITY

It’s good to know the difference between IDENT_CURRENT, @@IDENTITY,SCOPE_IDENTITY. Here is little bit more information about these terms. IDENT_CURRENT is similar to the SQL Server 2000 identity functions SCOPE_IDENTITY and @@IDENTITY. All three functions return last-generated identity values. However, the

Posted in Microsoft Technology Tagged with:

Difference between Inherits vs Src vs Codebehind & AutoEventWireUp

The @ Page Directive The @ Page directive specifies the Web Form attributes that are enabled, disabled, or the specific values, such as the transaction attributes of a Web Form. The ASP.NET Framework uses these attributes to provide the specific

Posted in Microsoft Technology Tagged with:

CSS ToolTip on mouse hover

We put sometimes  image for each field which gives brief description about that field. When we mouse over that image, small tooltip appeares which gives brief description about that field. Here is basic css code to create this type of

Posted in Microsoft Technology Tagged with:

Client-Side Validation of File Types Permissible to Upload

There are several methods you can use to control the types of files that are uploaded to the server. Unfortunately, there is no bullet-proof method to protect you from someone uploading files that would be considered malicious. You can take

Posted in Microsoft Technology Tagged with:

Working Around File Size Limitations In ASP.Net 2.0

We may not realize it, but there is a limit to the size of a file that can be uploaded using this technique. By default, the maximum size of a file to be uploaded to the server using the FileUpload

Posted in Microsoft Technology Tagged with:

Some Good ASP.Net Samples

Here is the good ASP.Net sample link http://www.daveandal.net/books/6744/samples.aspx

Posted in Link, Microsoft Technology Tagged with: ,

“Please wait..” Message for heavy loading task

I have one page that takes about a minute to load my data when my page gets loaded. Because we have a tons of data and complex sql query so obviously It will take times to run the query and

Posted in Microsoft Technology Tagged with:

Ads