Questions tagged [SQL Server] (1022)

2
answers

In MS SQL SMS 2008 R2 Express to watch the objects of MS SQL Server 2000 is similar to viewing them in QA?

Unfortunately, SMS 2008 R2 Express refuses to show the database objects SQL 2000, citing the lack of rights to sysusers. The administrator is not eager to give the right to select. Is it possible to add functionality to the environment SMS 2008 to work with database SQL 2000 in the Object Explorer same as the standard Query...
Tyre asked October 14th 19 at 12:01
5
answers

How to organize a NS server

Hello. Have a LAMP server it is BIND(the hosting). Purchased domain for example domain.com Tell me is it possible to configure BIND for that would when you purchase a new domain in the NS records it was possible to write something like ns1.domain.by. Or maybe someone could throw some links on this issue. About the organiza...
Sammy.Pur asked October 14th 19 at 10:24
1
answer

How to limit the number of messages sent per unit of time in Exchange 2003?

The question is: there are users who are doing large mailings, and so as already one domain fall into the black list DNSBL, you want to take all precautions to ensure that the situation is not repeated. How to limit the user the number of messages sent per unit of time in Exchange 2003? Thanks in advance for your answer. Go...
reed_Murazik asked October 10th 19 at 15:17
2
answers

MS SQL Server. T-SQL. The organization "change history"

I wanted to make any changes to a particular record in a particular table were monitored and it was always possible to revert to an older version. On reflection I prikol that it would be good to implement this on the DB level to avoid any lining application. Create mytable_history, with a signature identical to mytable, ...
Vince_Donnelly asked October 10th 19 at 14:23
3
answers

SQL Server is using 100% CPU?

The Hello! There is a problem with SQL Server 2008 R2 Enterprise. After the big changes to the data in the table (added a few million rows), SQL Server started to perform internal maintenance tasks and much shipping processor. Of course, the queries processing it has become much slower. The number of external requests in th...
Connor63 asked October 10th 19 at 13:03
0
answer

Intel MFSYS25 and SATA 2.5"?

Hello! Anyone have experience connecting to modular server system MFSYS25 Intel SATA 2.5" disk? Question especially to the owners of the audit is less than 008. What if just buy the adapter without changing power supplies and fans? Does anyone have any experience?
Sammy.Pur asked October 10th 19 at 12:40
0
answer

Cant with Asp.net and SqlDependecy

Sql Server 2005 and ASP.NET 3.5 The problem is known and is associated with a rapid filling ErrorLog sequel message type The query notification dialog on conversation handle '{F3EB22A6-CDB6-DF11-9BF1-003048CEA3F1}.' closed due to the following error: '-8490Cannot find the remote service 'SqlQueryNotificationService-558d19...
rogelio.Kertzma asked October 10th 19 at 11:27
3
answers

Which edition of mssql server to choose?

Not asked questions of licensing of software (all OS pre-installed was). Now we need to put the mssql server. The conditions are: 40-50 concurrent connections, volume of database, frequent queries. I think between MSSQL 2005 standard and Workgroup. What to choose, how much and where can you buy?
douglas.Williamson97 asked October 10th 19 at 10:44
2
answers

MSSQL and php.ini mssql.textlimit

The situation is this: our database are images in base64 in a field of type text when getting fields from PHP typical request — field image is clipped to 4096 bytes. How to get a field of normal length? Installed in php.ini mssql.textlimit = 2147483647 mssql.textsize = 2147483647 — does not help... Have found this solut...
Gennaro.Ebert asked October 10th 19 at 10:16
1
answer

Moving to Microsoft Project Server from one server to another

Hello everybody. There was a need to migrate one server with Microsoft Project Server 2007 from one railroad to another. And since earlier I used the settings of the project and not seen it, the question arose: "How this topic can be quick to hold?" In General, the idea is this: zabekapit the Project Server database on th...
Desiree_OConne asked October 10th 19 at 10:05