I am not sure what you intend to ask. From what I could understand about your requirement, it is not an option available in SQL Server. SQL Server asks for...

Yes it is in seconds and it is not uncommon to have that high value. When done a small calculation that # of seconds comes to a day (approx 24...

Have you tried creating a sql login (instead of using the Jef-PC\Jeff windows login). Give the newly created sql login sysadmin permissions on your instance and use that in your...

From my past experience, on an average there are more Developers than DBAs.. With the kind of job roles and responsibilities that are seen now a days, db developers are...

That counter value you see itself is the page life expectancy of your server. There is no average value to calculate...

Yes as Jeffrey has mentioned, you will have to have that password and use it here on this server. If you cannot find the pwd for the service account, ...

Thanks for checking Jason.. I haven't been staying active as I...

Have you tried this ? http://technet.microsoft.com/en-us/library/ms190757.aspx

I would agree with what others have already said.

To give my 2 cents. We have a set of backups (Full,Diff and Log) since the last full backup on the...

I am not great in writing scripts super fast.

From the look of it, you should try using Pivot, that should get you there..

Look at this link to read see...

Why do you need a Poll for this?

It is not possible to have Transaction Log Backups without Full backup.

You might be missing something, I would recommend you to look into...

USE sqlbox

GO

EXEC sp_addrolemember N'db_datareader', N'sam'

GO

One thing you can try is run the steps in the package individually one by one, so that you would know at what step is the DTS (Now SSIS) package...

There is nothing wrong to post your newbie questions in forums.

I assume, in the time it took for you to register in SSC and post...

afrinmou420 (5/22/2010)

---

Hello the below query will give is giving me users who are blocked in the past 2 days, I want to check what was their recent blocks and unblocks...