May I just add to avoid any N-typed datatype.

If you don't actualy need it, use varchar in stead of nvarchar.

We have recently had an issue where the same query on...

- 200mb for sqlserver isn't that much.

- How much RAM do you have on your PC ?

- Post the tables DDL (create statement, triggers, indexes,..)

- source : 25000 rows...

you may be better off putting this into a sqlagent job, owned by sa.

This avoids opening up xp_cmdshell for everybody :sick:

If you still encist on having this in tsql, put...

Indeed. The bug is known for a while now.

It would be nice if MS fixed that at least for the new downloads !

-what version of sql2008 are you using ?

-Did you check with sql2008 bol ?

- did you have a look at the SQL2008.Service_Broker.Samples.zip (codeplex) ?

- did you enable SSB for sql...

chandramohann (7/17/2008)

---

Yes the service is getting stopped. And the autorestart option is enabled. But even though the server is not getting auto started once it is stopped. We have to...

- I don't know if you should put this in your SQLServer engine :unsure:

- I think at SSC you'll find a clr module that queries AD to get expiration dates....

Can you post :

- the tables create statement (ddl)

- the partition function ddl statement

- the partition scheme ddl statement

- with the least overhead you could generate and execute truncate statements for every table. (truncate will only work if there are no FKs pointing to the table)

- or you...

VD (7/16/2008)

---

to SQLGuru,

can you please provide more info about the iLO driver bug? We've recently had issues with an HP box restarting without ANY errors in any of the...

it's the yolk that does it :w00t: 😀

Good notice Carl.

Another remark:

Keep in mind one should also join with information_schema.tables to find out what kind of table it is. (should be "base table" in this case)

information_schema.columns returns info...

try using this for the second test:

IF(@SFound = 1) SET @sql = @sql + 'ALTER TABLE [dbo].[ptNotes] ALTER COLUMN [Type] varchar(10) NULL;'

We've all had this kind of experience...

I hope this is not on a production database system.

Don't shrink the db unless you realy need to !

SQLServer needed the log-space to support your db !

Making a log-backup frees...

btw the HowTo for lock pages in memory:

See bol: "How to: Enable the Lock Pages in Memory Option (Windows)"

http://msdn2.microsoft.com/en-us/library/ms190730.aspx