Description:
Microsoft SQL Server newsgroup.
|
|
|
setting relationships through the enterprise manager
|
| |
I've very new to SQL Server and the Enterprise Manager. Can anyone point me to how to set up the relationships between the tables, and denoting which are the foreign keys? I'm coming from an Access 2k background, it that makes a difference. Regards, Shay B.
|
|
|
database snapshots -restoring status
|
| |
Hi, I had restored a production database backup to a TRAINING database using symantec.I accidently asked symantec to restore model,msdb and database snaphots to an existing TRAINING database. Symantec reported that there is database inconsistancies and when I check the instance, the database snapshots are in restoring status. What should I do to resolve the problem? Can I drop and recreate the database snaphots? How to know whether is there any connections to that database snapshots?... more »
|
|
|
Openquery to access azman roles
|
| |
Hi I am trying to access an AZMAN store that is located in ADAM from a sql query. I have written the query below but dont get any data. Is it possible to access AZMAN in the same way you would access AD? Thanks SELECT cn FROM OPENQUERY( ADSI, 'SELECT cn FROM ''LDAP://server:50000/CN=AzMan ADAMStore,OU=SecNetPartition,O =SecNet,C=US''... more »
|
|
|
SQL Server 2008 Opening files in Windows 7 Pro
|
| |
Not sure if I am in the corrct forum but here is my issue. I am evaluating Windows 7 professional for my company and so far the only bad feature I have found so far is when I am in SQL server 2008 Management studio, and I go to the folder to open an existing file on my local hard drive. I click on the folder, wait about 20-30 seconds and it opens my... more »
|
|
|
Bypass Installer for SQL 2005 Tools?
|
| |
I've been unable to install SQL Server 2005 Tools because it hangs at the same point every time. In the course of trying to address this, I learned about the advantages of doing things in SAFE mode. But apparently you can't run Windows Installer in SAFE mode. Can I install it by hand? Following is... more »
|
|
|
SQL Server 2005 - System Configuration Check stalls
|
| |
I'm tryin to install the client-side tools for SQL Server 2005 (Disk 2 of 2). It installs the required <stuff....- I forget the term> and then it starts a System Configuration Check. "SQL Server Setup is scanning your system's configuration." There's no CANCEL button and no X to close. And it's just been sitting there for three hours. Is there a log file... more »
|
|
|
SqlConnection Pooling and SQL 7.0
|
| |
I'm working with a legacy database, writing some testing routines against an old SQL 7.0 database. I've boiled the code down to: for(int loop = 0; loop < 4000; loop++) { using (SqlConnection c = new SqlConnection(cs.ToString()) { c.Open(); c.Close(); ...I'm getting connection errors: Verify that the instance name is correct and that SQL Server is configured... more »
|
|
|
Many incorrect syntax after virus? HELP!
|
| |
We had a trojan downloader infect our network and in the process of look at the network traffic I discovered that I was getting many syntax errors where the asp/web front end was making a call to a 2005 back end database and it would chop part of the next query or shorten the current query. What is really weird is that the .net client seems... more »
|
|
|
Cannot Open Port 1433
|
| |
Dear Friends, Im new to SQL and Windows Server 2003, I have configured the SQL server 2005 on Windows Server 2003 Starnderd version All the services of sql and Windows are starting properly .I can connect to server from client pcs and I can ping the server from client pc But I cannot open the port 1433 from... more »
|
|
|
|
