WilliamBendall (1/14/2010)

---

Hi,

Your reporting requirements will determine how you configure your reporting database. Your question can't really be answered here as we don't have enough information on your requirements.

From a...

sqlbuddy123 (1/13/2010)

---

Hi

I have a created a SQL Server 2005 login with pw password1

Now I want reset the pw...

You would obviously need to make some modifications to make it work with your table. I left the variable in there just for testing purposes and demonstration purposes.

This will probably work (so long...

You're welcome

adam 19559 (1/13/2010)

---

Hi There, thanks for getting back to me! After all the time i spent, you got way further then i did... i feel so average now lol

In the...

RedGate has a tool called Data Generator - that may be of help.

I think you probably have the first one figured out.

For the second date format, try the following:

Declare @datestring nvarchar(100)

Set @Datestring = 'Wednesday, 13 January 2010 11:48:44pm'

Select CONVERT(datetime,right(@DateString,len(@DateString) - charindex(' ',@datestring)),112)

I like your list - is it a Bucket List ;-)?

I find it interesting to see some of your items. Ironman is still one of my goals. I...

What kind of domain accounts? Are they domain admin or user accounts? What local groups on the server are the user added to on this server?

JWOL (1/12/2010)

---

What is the best practice for using certificates?

1. Is it best to have one certificate per database, create a user from the certificate then grant that user whatever rights...

Discretionary/optional would be what you deem best practices and necessary for your organization.

Mandatory controls are the types of practices required to pass audits and keep your network, data and organization...

Jack Corbett (1/13/2010)

---

There are pluses and minuses to both methods. I think form a pure security standpoint using Windows Users/groups is more secure for login reasons and also easier...

info 68917 (1/13/2010)

---

...

what i would like to do is to simulate say, 2000 more records to make the total count 3000. i would like to fill in this 'dummy data'...

Paul is giving away homework answers tonight.

http://www.sqlservercentral.com/Forums/Topic846696-338-1.aspx