Jpotucek (1/22/2010)

---

I am installing a new SQL Server 2005 named instance and I would like the server collation to be SQL_Latin1_General_CP1_CI_AS

which choices to a check off at setup to get...

I don't this so this will give you good results. consider the case if...

To shrink a file and give space to OS you have...

Replication monitor is there, if any thing goes wrong, that publication will be marked red if it is out of sync or if replication is failing.

To me there is no...

ramyours2003 (1/22/2010)

---

i want to determine the disk sizes whether to increase or not . as we are facing the backup jobs failed due to low disk space . on...

you can grant showplan permissions to public in model database.

If a database is created then all users by default will be having permissions to view showplan.

If a database is restored...

SD1999 (1/21/2010)

---

i found solution.....

http://support.microsoft.com/kb/307487

the only way to change 'initial size' for tempdb is

to shut down sql server

connect via cmd using sqlservr -c -f

Connect to SQL Server...

SD1999 (1/21/2010)

---

but this is my point.....

current allocated size is 1000 mb

and i want to split it to 4 256 mb

i will create 3 more data files later on...

Jack Corbett (1/21/2010)

---

Sounds like a user had been removed from the server and owned the job. I'd recommend changing the owner to sa or creating a user just used...

SD1999 (1/21/2010)

---

Thank you....

So basicaly when I'm specifying the new location for a tempdb datafile

I can specify a new size for that file at the same time in the same script...

I have a few questions:

You can make use of size parameter in the create\alter database command .

For example

create database <dbname>...

This is the query

select object_name(s2.id) as TableName,(sum(s1.reserved*8) )TableSize_In_KB,sum(s1.rowcnt)...

tvantonder-992012 (1/13/2010)

---

That was my first thought aswell. I did check it again and there is no missing log file. Why is the system alowing me te redo a restore that...

Hi Jeff and Steve,

Happy New Year.

Coming back to this topic. My task is to just to port the data from flat file most likely. So once I port...

Steve Jones - Editor (12/31/2009)

---

If you use BULK INSERT, you could check the table afterwards. I guess with bcp you could do the same. run a query and determine if...