The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
10 views

MSSQL administration tool without installation

I need a tool to have a look at mssql database and do some basic CRUD operations. To use it in every environment, it should be an installation-free EXE. Do you know such a tool? Before you ask: I ...
0
votes
1answer
13 views

Join 2 mssql queries

I need to join to MSSQL queries, but I am not getting anywhere with this. Both queries return a single value: SELECT COUNT(*) FROM sysjobhistory WHERE run_status <> 1 AND step_id = 0; ...
0
votes
0answers
10 views

Troubleshooting an Access rowsource query with a server name specified?

I have a list box rowsource query that addresses a specific MS SQL server in it: SELECT DISTINCT alistname FROM differentserver.dbo.Inventory ORDER BY alistname When I try to run this query in ...
0
votes
1answer
455 views

Remove column header from sql query output in powershell

I want to remove column header from sql server query output. I did the search but not found any solution. I have a script. $Database = "temp" $Server = "localhost" $AttachmentPath = "output.csv" # ...
0
votes
1answer
33 views

Can i input duplicate values in foreign key column

A small but important question can input null and duplicate values in foreign key column connected with some another table with same column identity and values as far of my knowledge it is not ...
2
votes
1answer
74 views

Excel inconsistent date conversion

I'm running Excel 2007. I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: ...
0
votes
1answer
274 views

What characters are allowed in in column (nvarchar 50) of MSSQL Server 2008?

I have a column in MSSQL which is nvarchar(50) in which I enter passwords for users. I know that for example some special characters like $ % are allowed, but where do I see which list characters are ...
0
votes
0answers
93 views

Cannot load riched20.dll into memory

In WindowsXP 64bit while installing MSSQL 2008 installation terminates showing error message "Cannot load riched20.dll into memory..." How to fix it?
2
votes
0answers
62 views

SQL Server is not started in windows 8

I created the local service. My server name is like sqlitesync.com. In my database folder created the configuration (web.config) and WCF web service (AuroraSyncService.svc). When I test this service ...
1
vote
2answers
1k views

MS SQL Server 2012 Express Setup crashes with .NET error

I'm trying to install MS SQL Server 2012 Express on a virtual machine at a client. It's fresh install of Windows Server 2008 R2 Enterprise SP1. I added the "File Services" and "Application Server" ...
0
votes
1answer
65 views

SSMS starts without login prompt and stays inactive

recently my SSMS started working really weird, wasting my time. I am working on a laptop connected to additional monitor. SSMS starts without login prompt, and stays inactive as long as I dont shut ...
0
votes
1answer
142 views

SQL server replication, subscription to remote server : issue while choosing the publisher

I am trying to create a subscription to a remote server having SQL 2008 R2 the client PC is connected through VPN to the server and can discover it successfully. I can even connect to the database ...
0
votes
1answer
50 views

What Microsoft product is used to draw a Relational Database for MS SQL?

What Microsoft product is used to draw a Relational Database for MS SQL? For MySQL I have used MySQL Workbench what is similar for MS SQL?
0
votes
1answer
190 views

Error importing database in Windows Azure

Just to test the MSSQL backup/restore capabilities of Windows Azure, I selected a test database and chose the "Export" option. It prompted me to select a storage location and I chose an appropriate ...
0
votes
2answers
269 views

What versions of Windows does MS-SQL come pre-installed on?

We have an emergency mgmt. application that runs on a flash drive so that in an emergency a PC can be commandeered to run the app. We are considering using MS-SQL instead of MS-Access, so I am ...
1
vote
1answer
206 views

Administrator can run a application but produces error while a administrator previllaged user can run without error

I have an application which can run as admin prevailed user without error but while administrator runs it it produces error. The input string was not in correct format-application error. I tried to ...
2
votes
1answer
390 views

WinSCP command line for SSIS package

I am using the command line : option batch on option confirm off open ftp:// username :password hostname:port cd directory name ---- directory on FTP option transfer binary put file name on FTP ...
0
votes
1answer
823 views

Access MS SQL server from CentOS (OpenOffice calc)

I installed FreeTDS in CentOS 6 and I can connect from php to remote MS SQL server. However I cannot set up odbc connection so that it shows in list of ODBC connections in OpenOffice apps. If my ...
0
votes
1answer
109 views

A proxy-kind program that listens on local port and transfers everything to LAN server

I'm administering a few WinXP machines from which one is a MSSQL server/workstation. WinXP is a must because of the program the office uses. I was thinking of moving the MSSQL server to another ...
1
vote
1answer
407 views

User Friendly CSV to MSSQL import with column match

Hi before I reinvent the wheel I'm trying find something to allow a user to take .csv files and graphically match the columns in the database table to the columns in the csv file. I know this can be ...
1
vote
1answer
498 views

Migrating Access Database to MSSQL backend

We have a database at cadets that uses Access for all functionality and data. It's starting to get slow and not always update. I know that Access 2003 and higher (not sure on older ones) lets you ...
0
votes
1answer
134 views

ADODB Connection - Webserver doesn't resolve the hostname of the mssql server

I have a mssql connection resource file as belows: <% Set Conn01 = Server.CreateObject ("ADODB.Connection") Conn01.Open "PROVIDER=SQLOLEDB; Data ...
2
votes
1answer
4k views

Event log warning Registry setting specifying configuration file does not exist

Microsoft SSIS Service: Registry setting specifying configuration file does not exist. Attempting to load default config file. For more information, see Help and Support Center at ...
0
votes
1answer
1k views

How do I make a dump of a MS SQL database using SQuirreL SQL?

Unfortunately I cannot use Microsoft's database tool to access my MS SQL server, so I need to use another tool like SQuirreL SQL. How can I make a backup (i.e. dump) of the database?
0
votes
1answer
2k views

Custom forms in Sharepoint with MS SQL Server as Backend. Is it possible?

We're evaluating using SharePoint 2010 as our project management tool. Specifically, the system needs to satisfy the following: Discussion groups Project management (simple issue tracking, no ...
2
votes
1answer
305 views

What program can be used to insert/modify/delete rows of MS SQL Compact?

MS SQL Server Management Studio 2010 seems not support compact databases (add/remove records). Is there any utility? Free one would be nice.
1
vote
1answer
227 views

SQLCMD -L option with a smaller timeout

I am trying to use the sqlcmd -L c command to find out the instance name of the SQL server running on the local machine. It succeeds, but I have to wait for a full minute, for the tool to realize that ...
0
votes
1answer
495 views

Looking For Live Exchange Backup Solution Utilitizing the Cloud (S3, Azure, whatever) [closed]

I have been tasked with finding some software or a service which can backup user mailboxes from a live Exchange server and SQL databases from MSSQL servers much like a Barracuda device might perform. ...
1
vote
1answer
775 views

Can't add PHP extension “mssql.so”

I want to add mssql.so extension to my PHP. I've already put it in the extension_dir and the line "extension=mssql.so" is in my php.ini. I restarted apache but I can't find the extension in ...
0
votes
2answers
16k views

What ports does MS SQL Server use for ODBC connections?

I require our firewall to allow ODBC connection from clients to the MS SQL Server. Which ports should be opened for this?
0
votes
1answer
191 views

Problem while installing Microsoft SQL Server 2008 as a user with Administrator rights

I am using Microsoft Windows XP service pack 3 User Accounts: VC3(Type: Administrator) and Administrator Question I am trying to install the Microsoft SQL Server 2008 in VC3 After half of the ...
2
votes
1answer
1k views

How to determine server name for ms sql

How do I determine the server name for ms sql server. How do I make one, if there is no default server name. I need this so that I could use it as a database Update: I tried using the computer name + ...
8
votes
9answers
15k views

Why does it take so long for SQL Management Studio to connect?

Considering that Microsoft SQL Server is not, technically, a slow database management system, I keep wondering why it often/usually takes such a long time for SQL Management Studio to connect. This ...