Hello Friends this category provides you to what to watch and what to not watch on every weekend. when some new Bollywood and Hollywood Movie will release on every Friday. please read this Blog and decide for which movie you want to wast your money or worth your money.

This Blog Update on every Friday when some new movie will release so please read this article before go to theaters.

What Ever you read in this Blog is not my personal comments these are the comments of Film Critic. Only thing is i read all the comments and creates rating on that basis of their and mine opinion .

This weekends movies and it`s rating.

Karzzzz : 1/5 Rating ( I wouldn’t even recommend it as a film that’s so bad it might be fun.This one’s just plain bad and I recommend you stay far away.Please don`t spoil your mood.)

Shoot On Sight : 2/5 Rating (it’s too simplistic and full of silly coincidences; yet there’s something important being said here, so it’s not an entirely pointless watch.)

Body Of Lies : 2/5 Rating (In this film DiCaprio and Crowe are both good, they always are. But neither can escape the pitfalls of this pointless film.Because it’s too long and goes around in circles, I’m going to go with two out of five and an average rating for Ridley Scott’s Body of Lies. It’s got its moments. But those moments are few and far between.)

Truly Inspired By Rajeev Masand.
Please Watch CNN IBN On Every Friday 10:30 PM and Get All Latest Movie Review.

Hello Friends this category provides you to what to watch and what to not watch on every weekend. when some new Bollywood and Hollywood Movie will release on every Friday. please read this Blog and decide for which movie you want to wast your money or worth your money.

This Blog Update on every Friday when some new movie will release so please read this article before go to theaters.

What Ever you read in this Blog is not my personal comments these are the comments of Film Critic. Only thing is i read all the comments and creates rating on that basis of their and mine opinion .

This weekends movies and it`s rating.

Hello : 1/5 Rating (Hello is not just a dull film, it’s an extremely stupid one. It’s one of those films that has virtually nothing good in it. )

Hello friends some guys asking me about is this any way to imports XML data into sql server table.

so friends here is answer of your question please follow the step and you will fill happy after task will done.
Step 1: Create  one table in the

CREATE TABLE Customer (ID int NOT NULL, Name xml)

Step 2: Then After  create a XML file .

<?xml version=”1.0″ encoding=”UTF-8″?>
<Customers>
<Customer ID=”1″>
<Name>Test</Name>
</Customer>
</Customers>

<Customers>
<Customer ID=”2″>
<Name>Data</Name>
</Customer>
</Customers>

Save this XML file name as test.xml into C:\ drive of your computer.

Step 3: Now import the xml data from C:\test.xml into  newly created table ‘Customer’

INSERT INTO Customer(ID, Name)
SELECT 1, Name
FROM
(
SELECT * FROM OPENROWSET(BULK ‘c:\test.xml’,SINGLE_BLOB) as Disc
) AS ImportXML (Disc)

Note: Do not forget to specify the UTF-8 encoding scheme in the XML file.

Enjoy Friends.

Hello Guys and Girls what i servers you is some nice thing for sql server users.

if you want to find out the users logged in a database then we have to use some of system views.

sys.sysprocesses is one of them.

select * from sys.sysprocesses;

it will returns the host name , login name , window user name and processes.

if you want to know more stuff of  sys.sysprocesses then go here

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

some more Store procedures provides same stuff

EXEC sp_who

EXEC sp_who2

sp_who provides information about current users, sessions, and processes in an instance of SQL Server.

Enjoy Friends

hello frineds if you need to know that how much space occupied by your each tables which was created by you.

this is the shortest way for any sql server user.

USE yourdatabasename
EXEC sp_MSforeachtable @command1=”EXEC sp_spaceused ‘?’”

Enjoy all guys and girls.

Hello Friends one requriment face last days from my boss was he said me that get all active connection in any database in sql server. mean give me list of all user which are currently connected to the our live database.

so fullfill this requriment with below solution so please write this query it will make your boss happier also

this query is for all database on server.

SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame

please tell your boss and get increment in your salary.

Hello Friends many People install sql server 2005 and then after they want to change system admin password mean “sa” password.

i give you two way to change “sa” password one is if you don`t know the password then do following stuff in your query window.
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
USE [master]
ALTER LOGIN [sa] WITH PASSWORD=N’NewPassword’

Second Way is you may be  remember your Old Password and want to change the ‘sa’ password then do following stuff.

ALTER LOGIN [sa] WITH PASSWORD = N’MyNewPassword’ OLD_PASSWORD = ‘MyOldPassword’;

Enjoy Boys and Girls.