User password is expired.

Yes SQLProfiler will help you in finding users who are connected to your server. Can you please tell if your application is using standard SQL Server port???

Can you please give the name of the proc which you are trying to create...

Depends what you are trying to do. If you are trying to create the maintenance plan for backing up the transaction log of all databases on sever than maintenance plan...

looks like sp you are writing has got logical errors and their is no way tsql will pick them. you need to look at your logic.... 😉

Check your drive for bad sectors because if your drive has bad sectors it will not be able to use that space.

I think its not true, I have installed Named Instance and then installed the default instance. I thinks is some thing wrong with your initial installation...

Ideal way of checking the job status is using the Activity Monitor because with Job Activity Monitory you can do the following...

- Create and Apply Filter for all executing jobs.

-...

Please see the instructions to accomplish the desired object:

- BCP operating system command to export the data into the text file.

- Right-Click the table and choose Script Table As ...

Hi Micheal,

Try this..

DECLARE @sunday datetime;

SET @sunday = (select dateadd(d,-1*datediff(d,'20080106',getdate())%7,getdate()));

SELECT @sunday

Nope. Its a good practice to have xml indexes on thoes xml colums that stores long complex xml data.

Because you are not selecting the whole script and also the correct way of writing that is as follow:

DECLARE @sunday datetime;

SET @sunday = (Select DATEADD(week, DATEDIFF(week, 6, getdate()) -1, 6));

SELECT...

Hi,

You cannot partition the existing table using ALTER TABLE statement. But if you want to create the partition of the existing table then follow these steps:

- Rename your existing table....

You can use DCL (Data Control Language) to ristrict the user access on the tables of the database.

For more information on DCL please use the Microsoft Books online...

Integrated Security = true;