Administering

• Topics

  Started by

  Posts

  Last post

• EXEC xp_cmdshell

  EXEC xp_cmdshell 'findstr "DWG" E:\ABC\XYZ\123a.TXT > E:\ABC\XYZ\987a.TXT' file is not creating …

  Nagabhushan

  3 replies

  14 years ago

  By: Jeff Moden

• How to Send mail from Sql mail to mobile ?

  I want to send alert mail from sql server 2005 (database mail ) to indian mobile ? Please any one …

  solomon.jernas

  5 replies

  14 years ago

  By: Divine Flame

• Changing smalldatetime field to datetime

  Hi Guys, I want to change a field from smalldatetime to datetime because somedate have years like 1…

  river1

  1 replies

  14 years ago

  By: Ant-Green

• Need Help:The free space in properties of TempDB shows 95% free space. But the Data files dont have any free space.

  The free space in properties of TempDB shows 95% free space. But the Data files dont have any free …

  hemanthnightmoon

  6 replies

  14 years ago

  By: Jack Corbett

• Bug with restricted file growth

  Hi Friends, We encountered a bug with restricted file growth on our MSSQL 2005 infrastructure. We'r…

  sps-554505

  10 replies

  14 years ago

  By: yup

• tlog backup to the system databases

  hi, We can take the tlog backup of the databases 'model'.... but not for 'master', 'msdb' and 'mode…

  SQL_Hunt

  5 replies

  14 years ago

  By: Gail Shaw

• DTS package failed

  Hello, my DTS package failed this morning and I don't know what this error means: Executed as user:…

  Krasavita

  4 replies

  14 years ago

  By: Krasavita

• adding files to master/model and msdb

  hi, We can add one more file to the database: msdb..why not for master or model? Thanks.

  SQL_Hunt

  1 replies

  14 years ago

  By: Gail Shaw

• Model DB is in Full recovery model, whereas rest all the databases are with recovery model as Simple.

  hi, Can you please let me know the architecture behind creating the model databases (by default) as…

  SQL_Hunt

  4 replies

  14 years ago

  By: Gail Shaw

• Max number of user connections available...

  hi, Can anyone please advise, what are the maximum number of user connections allowed in each diffe…

  SQL_Hunt

  1 replies

  14 years ago

  By: Ant-Green

• Reinstall after disk failure on Sql 2005 server

  I did a stupid trick..... My server had to have a disk drive replaced which meant I needed to rein…

  jude-32296

  3 replies

  14 years ago

  By: Schadenfreude-Mei

• Blocking TempDB: (15ms)PAGELATCH_UP:tempdb:8(PFS)

  So, I seem to be having a good opportunity to learn about tempdb contention. Here's what I've got:…

  Fly Girl

  15 replies

  14 years ago

  By: Gail Shaw

• SQL Server changes - to –

  So, App guys are using SSIS packages which call Bulk Load options to load the data from txt file (A…

  SQLRocker

  1 replies

  14 years ago

  By: SQLRocker

• Cached plans getting pushed out of memory?

  I'm working with a legacy SQL Server machine: SQL Server 2005 SP2 Windows Server 2003 Enterprise …

  Jesse Reich

  6 replies

  14 years ago

  By: Orlando Colamatteo

• Linked Server missing tables

  Hi All, On my dev machine (laptop) I'm trying to connect several servers to my dev machine using Li…

  Michael Lee-158245

  1 replies

  14 years ago

  By: Lowell