No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0VotesUnable to connect to SQL Server 2012 from Visual Studio 2008 Server Explorer
Hi: I am having Visual Studio 2008 with Service Pack 1. My Database is recently migrated from SQL Server 2005 to SQL Server 2012. ... -
Unanswered1VotesGetting error while configuring UCP
Synonym 'dbo.syn_sysutility_ucp_smo_servers' refers to an invalid object. Could not use view or function 'msdb.dbo.sysutility_ucp_instances' because of binding errors. (Microsoft ... -
Unanswered0VotesALM - Visual Studio Database Projects and Data Warehousing
I have moved onto a team doing data warehousing. In the past I have performed application lifecycle managment using Visual Studio and TFS for web and test projects. I am helping my current team define ... -
Unanswered1VotesLogin failed for user "NT AUTHORITY\ANONYMOUS LOGON'
Hi guys, I've been looking for a solution for this for the passed 3 days. I have performed numerous tests & solutions but have not been able to make it ... -
Unanswered0VotesLinked Server Problem while SQL Data Transfer using Non-sys Admin Account
Hi Team, I've an issue while transferring the data from ServerA to ServerB. I've made the ServerB as "Linked Server" to Server A. Pre requisite like: 1) ... -
Unanswered0VotesHOW TO FORMAT AND SET-UP TO IMPORT ASCII CALIF CORP FILE BY CALIF SECRETARY OF STATE?
Dear Sir: I purchased a California Corporation file (3 Million records) from California Secretary of State. It is a ASCII format. I used a column import with fixed width (SQL ... -
Unanswered0VotesSQL Server 2012 Developer SP1 installation faillure
Hello, I've tried to instal SQL server 2012 developer SP1 on a windows 7 home premium x64 laptop but i get the following error "The SQL Server license agreement cannot be located for ... -
Answered0VotesMulti Server Maintenance plan not downloading to TSX
Hi guys I am trying to setup multi server admin. I have done this on test environment and everything worked fine. Now on the prod servers it does not want to work with ... -
Answered0VotesAutomate SQL 2012 policy management with powershell
Hello. I´m trying to automate policy management via Powershell and I´m running into some problems. What I want to do is register a SQL 2012 server to a group in ... -
Answered0VotesQuery using two servers
how do I query to another server? I want to use a connect statement but am running into errors I get this ... -
Answered1VotesMicrosoft SQL Server,Error: 5120
I am trying to attach a database to SQL server 2008 R2. and i get an error message says . Attach database failed for server 'SMSM-PC'. ... -
Answered1VotesSQL Server 2008 R2 Data Tier Applications
I am using Data Tier Applications in SQL Server 2008 R2. When I use Extract Data Tier Application Wizard, everything works fine and I could create a .dacpac file. But when I tried to deploy the same ... -
Proposed2VotesLink Server Problem
Hello I have 2 window dedicated server, both are window 2008 R2 with SQL Server. I created linkserver on both server but when ... -
Answered0VotesMSX enlist failed
Hi all I am loosing the will to live here trying to setup this multi server administration. I have gone through all the previous posts and made all the required ... -
Answered0VotesUnable to connect SQL Server from Client
I cannot connect to Sql Server from windows 7 professional, core i5, 8 GB Ram, 64 bit HP Branded Desktop to the SQL server 2005 installed in Windows 2003 server 32 bit. During ... -
Answered0VotesRecord Locking in vb6.0
In my vb6.0 project the db has to use multiple user, but when user1 open the form and user2 also open the same record, for user2 getting the error-'the record is locked by another user'. I want ... -
Answered0VotesLinkage error
OLE DB provider "SQLNCLI10" for linked server "10.196.128.135" returned message "A network-related or instance-specific error has occurred while establishing a connection to ... -
Proposed1VotesHow to Join a Query in sql server 2008
AT PRESENT I GET THE REPORT PERFECTLY BY USING THE BELLOW QUERY BUT IT TAKES TOO MUCH TIME FOR EXECUTION. SO I NEED TO SIMPLIFY THE QUERY FOR FAST RESULT USING JOINS OR ANY ... -
Answered1VotesDistributed OLTP question
I’m a DBA at a SaaS company managing high volume OLTP traffic with a tight SLA focused on response time. I’m tasked with bringing up a new data center with our next generation ... -
Discussion0VotesWhat is the best data sync option?
We configured merge replication to our production database. At present DB size is like 15GB. Its going to getting increase. In merger process, we are facing somany issues, the ... - Items 1 to 20 of 298 Next ›


