auto genrate a code in sql

im using microsoft sql server. i would like to generate a code for the items of the table im using i want the code to look like this AA/034, AA/365...... AA is a simple serie of number that will not change and the 034 or 365 is the number of the days in a year so the code will not be unique ; the same code will be attributed to all the re...

Powershell to configure SQL Server Facets

has anyone tried configuring SQL Server Facets using powershell... i tried with below code..and i am able to find out properties of the Facets but not getting idea on how to set values to these properties. [System.Reflection.Assembly]::LoadWithPa rtialName('Microsoft.SqlServer.Dmf') | Out-Null [System.Reflection.Assembly]::LoadWithPa rtialN...

Can't connect to Microsoft SQL server

So I downloaded the SQL suite with the server and im trying to connect to my server through visual studio database explorer. I select: Data source: Microsoft SQL Server(SqlClient) Server name: ?? but I tried everything for the server name, and it doesn't show me a list of databases on that server, just comes up empty( tried localhost/root...

Locate DTS package SQL Server 2005

The system is SQL Server 2005 (Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7600: ) on Windows SBS2011 64bit machine The database was upgraded from SQL Server 2000 recently (not by me, so at the moment I do not know the proc...

Is it possible to xcopy deploy the Microsoft ReportViewer web control?

I'm trying to setup Microsoft reporting on a shared hosted server. I've set up the web.config files with the necessary entries and uploaded the assemblies Microsoft.ReportViewer.Common.dll Microsoft.ReportViewer.WebForms.dll as well as the file Microsoft.ReportViewer.xml via FTP. The site loads OK, but when I try to load a report a get a...

C# smo project assembly not referenced error

I am doing a C# project which is using smo objects(Server,Database). I included using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Server; I have added Microsoft.SqlServer.Management.Smo,Micro soft.SqlServer.Management.SmoExtended,Mi crosoft.SqlServer.SqlEnum,Microsoft.SqlS erver.ConnectionInfo. But still i am getting the e...

Using dotNetInstaller to check whether SQL Server 2008 is installed

I am trying to create a bootstrapper with dotNetInstaller for my application which needs Microsoft SQL Server 2005 Backward Compatibility Components . I have added a check for that using the pre-built components. All was good till I realized that I need to check for SQL Server 2008 installation before installing Microsoft SQL Server 2005...

Cannot Open Microsoft SQL Server Management Studio

I have a big problem. While am opening Microsoft SQL Server Management Studio it appears me an error: "Cannot find one or more components. Please reinstall the application" I was searching solutions in Internet but I didn't found anything helpful. I have SQL Server 2012 and Windows Server 2008 R2. Some suggestion? Thanks.

JDBC Connection Exception with MS SQL Server 2008

I am using windows server 2003 on VM vare on which I have my database on MS SQL Server 2008 . Now when I used jdbc driver to connect my java code with database I am getting following exception. Kindly give some solution . Exception in thread "main" java.lang.UnsatisfiedLinkError: com.microsoft.sqlserver.jdbc.Authenticat ionJNI.SNISecGenCli...

auto height in multiline textbox

I have to show data from database with multiline textbox. How can i set height auto in this multiline textbox? My code is here, <asp:TextBox ID="txtNaiyo" runat="server" TextMode="MultiLine" Rows="5" Width="100%" style="height:auto;" Value='<%# Eval("Naiyo") %>'/>...

CU3 for SQL2012 SP1 – Couple of interesting hotfixes.

Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1 . You can download the same from http://support.microsoft.com/kb/2812412 Similar to CU2 there are some interesting hotfixes which are included in this CU release, and its worth testing it out. The ones which attracted my attention are - 2800013 http://support.microsoft.com/kb/28...

Configuring nginx web server with multiple app server of aws stack

I am a develops guy and presently I am running my Ruby on Rails application on ubuntu ec2 where the app and also the web server residence inside the same box but we are using mysql RDS cluster.. But I can see lot of spikes due to the more traffic to the web site.SO I a planning to change the system. I wanna put webserver nginx in a separa...

Visual C# 2008 Express connection to SQL Server 2008 Express Issue

I have a problem with Visual C# 2008 express (SP1) connecting to SQL Server 2008 express. The "Add Connection" window (wherever initiated) doesn't list existing sql server and no option for sql server except a compact edition. Note that, I've got the VWD 2008 express (SP1) on the same machine which shows the window regularly (with SQL ser...

How do I set the timeout for the execution of a set of statements when using the SQL Server SMO libraries?

I have the following bit of code that is timing out when I pass it a long running set of SQL statements. I'm using the Microsoft.SqlServer.Management.Smo library from SQL Server 2008. Using cn As SqlConnection = GetConnection(_destinationCNS, True) Dim smoServer As New Microsoft.SqlServer.Management.Smo.Serve r(New ServerConnec...

Selling all my domains, aged 10+ years cardstudio.com

I'm getting out of the domain business for the most part. Serious offers only, no "what are you asking for?" because I don't have set prices at the moment. Most are aged 10+ years. Domains are at enom. Expirations listed. adultproviders.com 11/30/2013 auto authoring.org 4/26/2013 auto b-sides.com 2013-07-20 (moniker) BANGMOBILE.com 7/2...

Pydev, auto code format all files in an eclipse project

Please suggest a way to auto format all py files in an eclipse project using pydev auto code format. We're using the pydev code formatter to make our code consistent and would really like to get all files standardized. Since we've enabled code formatting in pydev, every time a py file is touched by pydev, it gets changed at many places on...

Could not load file or assembly 'Microsoft.Web.Design.Server

Help please, I am having an error on the TFS. it complains that it cannot load the assembly below. the project works fine on my computer. I searched for the dll by there is no such dll called: Microsoft.Web.Design.Server. Any help pelase? System.IO.FileNotFoundException: , Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c...

How does the 'fx' queue in jquery auto start?

I have read many answers and blog posts on the jQuery queues... and specifically this particular answer has helped a lot - http://stackoverflow.com/a/3314877/13158 11 . But, both standard docs on jquery.com and the answer above got me to look at the jquery code http://code.jquery.com/jquery-1.7.2.js What I cannot understand from the code...

How to find out server response code using java

I have a doubt on this matter. How can we identify the server response code by using java code. I mean if we got any response from server as a HTTP response , we can able to print this as string or whatever. I wanted to know how can we track if some particular request is being hit in the server using java also find out the server response...

Access Denied to files after coping to Server 2012

I have an ASP.NET application where my client has moved from Microsoft Server 2008 R2 to Microsoft Server 2012. My application saves and removes files from a local folder that we give permissions on. This works fine, I can add and remove uploaded files with ease. The problem is, that any of the files that were uploaded from the old Server...

WCF Beginner Tutorial - Unable to debug (step into)

I am doing the following tutorial http://msdn.microsoft.com/en-us/library/ ms731835%28v=vs.100%29.aspx and the program is working perfectly fine. Both Service and Client are in different solutions. I can start the service from one visual studio and then run the client program successfully. However I want to do debugging. I want to step in...

flash on 2012-9-4

Connected to Compiler Server. Sending Code to Compiler Server... Flex Compiler Boot Complete Compiling... Compile Complete (5864 bytes) Reloading swf Auto Saved Taking Capture... Sending Capture to Server... Capture Saved...

Tool to make complicated setup (InstallShield or custom app)

I'm looking into creating a user friendly setup wizard which does the following: Ask the user for a server name. Ask the user for a database name. Ask the user for a Microsoft Nav database name and server Setups database in SQL Server (with info provided in number 3) Runs setup scripts in SQL Server Runs setup of server app (which I have...

Windows RT 8.1 Preview and Windows Server 2012 R2 revealed

* in leaked code* -Quote- While Microsoft is preparing to unveil a public preview of Windows 8.1, it looks like Windows RT and Windows Server 2012 users won't be left out of the new upgrade cycle. A recently leaked build of Windows 8.1 has revealed references to a Windows RT 8.1 Preview and Windows Server 2012 R2 in the code of...

File server for company

Hi i am wondering what are some of the better software solutions for a file server nowadays? Does microsoft server 2012 have build in file recovery or is it still better to use something like Symantec backup exec on the server?...

IIS7 returning 500 for status code 401 when asp.net mvc app writes it to the response

Our mvc application sets the response status code to 401 and sets TrySkipIisCustomErrors to true under some circumstances. I can see from the IIS log that it is getting this status code: 2012-05-04 01:32:42 10.212.98.183 POST /v1.07/session - 80 - 10.24.22.26 curl/7.20.1+(i686-pc-cygwin)+libcurl/7.2 0.1+OpenSSL/0.9.8r+zlib/1.2.5+libidn/1.1 ...

C# Execute batch of microsoft translation queries

We are trying to use Microsoft translation service provided on Azure market place. I started with the sample code provided at http://code.msdn.microsoft.com/windowsaz ure/Walkthrough-Translator-in-7e0be0f7/v iew/SourceCode Using their sample code I can get a single translation. However I would like to get multiple translations in a single r...

Migrating MS Access 2007 db to Sql Server 2008

I'm trying to use the SSMS migration tool to a newly fresh database on the SQL server and I get bunch of errors that I can't understand. any suggestions for a better way, or to direct me to solve the problem ? Thanks Copying to [dbo].[Vehicle$] (Error) Messages Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE...

How to convert Oracle procedures to Microsoft SQL Server?

I've been searching for a free tool that can convert Oracle stored procedures, functions and packages to Microsoft SQL Server. Actually these two databases are too different and I've managed to find only one free tool that can do such a conversion well. It’s Ispirer Free Online Database Converter but it’s limited to conversion of only 20...

BlackBerry Enterprise Server v5.0.4 Maintenance Release 2

The following software are now available for download: for Microsoft Exchange for IBM Lotus Domino for Novell Groupwise Note: This release adds support for Microsoft Lync 2013 to BlackBerry Enterprise IM. No new BlackBerry Enterprise IM client is required - the current client available for end users on BlackBerry OS 5.0-7.1 smartphone...

so many Microsoft Press books for Exam 70-410 - which one?

I did MCSE NT 4.0. There was official MS study guide. Now see so many Microsoft press guides. Which one? What's difference? Exam Ref 70-410: Installing and Configuring Windows Server® 2012: Craig Zacker: 9780735673168: Amazon.com: Books Exam 70-410 Installing and Configuring Windows Server 2012 (Microsoft Official Academic Course Series)...

Exchange Server 2010 SP3; Server 2010 SP2 UR6 and Exchange 2007 SP3 RU10 Released

Microsoft earlier in the day released twelve security bulletins addressing 57 vulnerabilities in Microsoft Windows, Office, Internet Explorer, Exchange and .NET Framework. In the, Exchange releated update security bulletin MS13-012 (KB 2809279) rolls out: Update Rollup 6 for Exchange Server 2010 Service Pack 2 , contains a number of cust...

MS Dynamics NAV XML Namespace is set automatically

im creating a new XML File out of a table. The problem is i dont want the children of the root node to have the attribute xmlns. This happens automaticaly and its incorrect. If i have the attribute on the root element, no matter how it gets there it puts it in its child-nodes. How can i get ridd of it? Thanks in advance. Locals Name DataT...

Want to connect PHP5 to MS SQL SERVER 2005 in linux

I want to connect mssql server using php code on linux operating system. i want to use mssql_connect() .please help me. my code is $server='x.x.x.x\SQLEXPRESS'; $link = mssql_connect($server, 'username', 'password'); if (!$link) die("Couldn't connect to SQL Server on $server. Error: " . mssql_get_last_message()); echo "Connected!"; it...

Ошибка при подключении sqlsrv_connect - SQL Server

Добрый день, пишу интерфейс к базе на php, с базой столкнулась впервые. SQL Server 2008 + php 5.3.1 + apache 2 При подключении выдает ошибку Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the M...

Совместимость с Microsoft SQL Server - C++ Builder и базы данных

Только начинаю изучать sql сервер и c++ builder. Будут ли совместимы для работы Microsoft Visual Studio 2010 и БД из Microsoft SQL SERVER 2012?...

error هنگام atach کردن برای فلش

وقتی روی دیتابیس میرم و می خوام atachکنم، پس از addکردن وقتی okمی کنم error زیر ظاهر می شود. لطفا راهنمایی بفرمایید. TITLE: Microsoft SQL Server Management Studio Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdN...r &LinkId=20476 ADDITIONAL INFORMATION:...

مشکل در اتچ کردن دیتابیس به اس کیو ال سرور 2005

با سلام من میخوام دیتابیسم رو اتچ کنم ولی ارور میدهد کسی میتونه راهنماییم کنه با تشکر اینم ارورش TITLE: Microsoft SQL Server Management Studio Attach database failed for Server 'MOHSEN-PC'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdN...r &LinkId=20476 ADDITIONAL INFORMATION: An exception occurred while e...

[Débutant] Hello World avec SharePoint

Bonjour , je suis débutante en SharePoint. En fait j'essaye de développer mon premier petit projet sharepoint. J'ai installé Sharepoint Server 2010 et Microsoft Visual Studio 2010 sur Microsoft Windows Server 2008 R2. J'essaye avec cet exemple ici Mais le problème que j'ai pas trouvé l'assembly dans C:\WINDOWS ssembly. Où je le trouve alo...

Не удается подключится к локальному серверу - SQL Server

Тема не новая, но нигде внятного объяснения решения ее я не нашел. Сегодня, запустив Среду Microsoft SQL Server Management Studio, при попытке подключения к локальному серверу выбило ошибку: Цитата: ЗАГОЛОВОК: Соединение с сервером Не удается подключиться к (local). ДОПОЛНИТЕЛЬНЫЕ СВЕДЕНИЯ: При установлении соединения с SQL Server произо...