There ar emany ways to do it. This is just an example for the date in character format

Something like this:

SELECT * FROM dbo.YourTable

WHERE YourColumn =

CAST(DATEPART(year,DATEADD(month,1,GETDATE())) as VARCHAR(4))+'/'

+REPLICATE('0', 2 - DATALENGTH(CAST(DATEPART(month,DATEADD(month,1,GETDATE())) as VARCHAR(2))))

+CAST(DATEPART(month,DATEADD(month,1,GETDATE())) as VARCHAR(2))+'/'

+REPLICATE('0', 2 - DATALENGTH(CAST(DATEPART(day,DATEADD(month,1,GETDATE())) as VARCHAR(2))))

+CAST(DATEPART(day,DATEADD(month,1,GETDATE())) as VARCHAR(2))

In general - yes, but it depends on your environment. If you don't have too complicated environment - reinstall SharePoint, create application pools and web applications, then using Central Administration...

Hi,

Verify registry keys permissions for the service account. Full list of required permissions is here: http://support.microsoft.com/kb/283811

You can schedule jobs with dtutil command to copy SSIS packages. I have never used the solution provided in article below, but it may help you:

http://www.databasejournal.com/features/mssql/article.php/3734096/Using-dtutil-to-copy-SSIS-packages-stored-in-SQL-Server.htm

Hi,

The difference is that if a user doesn't specify old password then he/she must have CONTROL SERVER permission to change thier own password.

In order to give users ability change thier...

Hi,

You can find role members by running this query:

EXEC msdb..sp_helprolemember 'db_dtsadmin'

More details about SSIS roles are here: http://msdn.microsoft.com/en-us/library/ms141053(SQL.90).aspx

Hi,

You need to use INSTALLSQLDIR parameter.

The role has to be created in master database.

If you use SQL Server 64 bit then you need to add "Lock pages in memory" permissions to the SQL Server Service Account using Group Policy tool.

Do you have Windows and SQL Server 32 bit or 64 bit?

Could you check the database status and run CheckDB? One of the reasons you can get this error is when the database is offline.

EXEC sp_helpdb 'UserDB'

GO

DBCC CHECKDB('UserDB')

GO

Try to add -S (Servername) option to OSQL command.

You can start from checking you tape backups schedules. If they run at the same time you can get this error. Sometimes antivirus can cause these errors as well....

If you mean "Performance - Top Queries by Total CPU Time" report then yes, this is "Number of times that the plan has been executed since it was last compiled."....