Server Configuration
in [Microsoft SQL Server]
|
event id 4879 MSDTC Client 2 Hi ! I have a problem with an application on a windows server 2008 r2. This application works ok on all clients running windows x32. But when I run it on my server it crashes with event id 4879 MSDTC Client 2 encoured a problem contacting the server itself. I've tried the binacle to set permissions to networ... 5 Jun 2010 15:50
Scripting Tables in 2008 SSMS I saw Tom's query (of April 2009) on the above subject on Google groups - I am now facing the same problem. I used to have SQL 2005, upgraded(?) to SQL 2008 Express and then on to SQL 2008 Standard. Did anyone ever get an answer other than John Bell's telling Tom to write his own SMO script? Does anyone know ... 8 Jun 2010 06:57
coallating designator and sort order Hi, in 2005 MS SQL , how can I see coallating designator and sort order of my instance ? Thanks. ... 4 Jun 2010 10:21
pack service SP3 Hi, for MSSQL 2005, is pack service SP3 cumulative (should I install SP2 first or not) ? Thank you. ... 6 Jun 2010 01:38
Import Database Schema from BDE into SQL Server Hi, I know this might not be a good place for this post, so forgive me. I have an old application storing it's data on BDE. I want to see it's database schema and if possible import it to SQL Server 2005 or 2008. Some other things: I know nothing about BDE. I have not written the application. It is an old appli... 3 Jun 2010 21:16
SQL Maintenance and Backup plans I have downloaded the SQL Server 2008 developer and workgroup editions. I have installed them my computer and I am trying to develop maintenance and backup plans. However, either edition developer or workgroup have this functionality provided by the installation. Can you please explain why this is the case? ... 7 Jun 2010 10:47
Partition ? Hi. I have a database with a single data file. Is there any performance gain if table are partitioned in SQL Server 2008 and placed on same partition of a hard disk? Regards, Muhammad Bilal ... 3 Jun 2010 17:55
nvarchar max Hi We had a sql server databse on the web server which used ntext fields as it was in 2000 We ugraded to 2005 and recently i changed the ntext fields to nvarchar(MAX) so i could use distinct in sql Since then we have had massive problems with the server with sql consuming 90-100% of memory. I was no... 3 Jun 2010 17:55
bcp error Hi, on MS SQL server 2005, I receive the following error : bcp PSOPRDEFN format nul -T -c -f C:/somefile.fmt Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'format'. Any idea ? Thank you. ... 4 Jun 2010 03:47 |