Joel Ewald (12/9/2008)

---

you can change the system time on your SQL servers to be all the same timezone or you can have the timezone accurate for each location and insert...

I agree, you want to set the maximum memory for SQL Server. Giving the OS 2 gig (even though this server is only a database server) will help ensure...

I agree with Michael that RedGate's SQL Compare is a fine product, we use it for the very same purpose you're looking for where I work. I've also worked...

fizzerchris (12/8/2008)

---

In my scenario, I do full database backups every night. I'm wanting to have some sort of recovery of the day's work, say every 15 minutes.

I...

It depends on what datatype the column is and which "system views" you are using.

The easiest one to use is information_schema.columns

it has character_maximum_length column for CHAR, NCHAR, VARCHAR, NVARCHAR columns,...

I have a few comments:

- the main problem you are probably having is that your EXEC statement with dynamic SQL will be in a different scope than the @Startdate...

Frank Cazabon (12/8/2008)

---

Thanks Chris,

could you clarify what would be needed if I have SQL Server Workgroup or Standard at the head office? My guess is that I will need...

Books Online says that querying this table requires the permission "VIEW DATABASE STATE", so they don't need to be a DBA, just have this granted to them.:

http://msdn.microsoft.com/en-us/library/ms187737.aspx

Joe Contreras (12/7/2008)

---

...I can have multiple states associated with a single rate and I can have multiple rates for a single state.

...

I have 2500 records in the state table (which...

jean-marc.reynaud (12/8/2008)

---

...My basic question is this: Should we use multiple databases or multiple schemas?

Related to this are questions of ease of management and scalebility: Which option is easier to manage?...

Frank Cazabon (12/3/2008)

---

...So if they use Workgroup or Standard version at the head office, then SQL Express at the remote sites, the remote sites can subscribe to get any changes...

To store the results of the query into a variable you can do something like:

DECLARE @body varchar(8000)

SET @body = ''

SELECT @body = @body + s.name + '.' + t.name +...

I'm not sure that...

...reminds me of the old joke: How many Microsoft programmers does it take to change a lightbulb? 0, they declare darkness the...

I've never tried the Fuzzy logic or Google API approach, but I did make a fairly decent tool to standardize addresses using the US Post office abbreviations (there should be...