Viewing 15 posts - 31 through 45 (of 56 total)
User password is expired.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 23, 2008 at 5:36 am
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???
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 23, 2008 at 4:10 am
Can you please give the name of the proc which you are trying to create...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 23, 2008 at 2:44 am
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...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 23, 2008 at 2:41 am
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.... 😉
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 23, 2008 at 2:10 am
Check your drive for bad sectors because if your drive has bad sectors it will not be able to use that space.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 23, 2008 at 2:06 am
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...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 19, 2008 at 9:05 am
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.
-...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 16, 2008 at 6:02 am
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 ...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 16, 2008 at 5:51 am
Hi Micheal,
Try this..
DECLARE @sunday datetime;
SET @sunday = (select dateadd(d,-1*datediff(d,'20080106',getdate())%7,getdate()));
SELECT @sunday
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 16, 2008 at 4:59 am
Nope. Its a good practice to have xml indexes on thoes xml colums that stores long complex xml data.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 16, 2008 at 4:55 am
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...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 16, 2008 at 4:46 am
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....
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 16, 2008 at 4:34 am
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...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 16, 2008 at 4:24 am
Integrated Security = true;
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 13, 2008 at 6:25 am
Viewing 15 posts - 31 through 45 (of 56 total)