Accessing another database using a variable
I have a select like this:SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY bwhere a.part_id = b.part_idIs it possible to use a @variable to identify the other database, rather than hard coding it? (I've tried @db2.INVENTORY b) but SQL SERVER 2000 doesn't like...
View Answer
| Oct 9 2008 4:22 PM GMT
| asked by
CO Bill
SQL Server 2000, Variables, SELECT statement
Analyzing Existing Indexes
Hello,I am trying to analyze existing indexes on few tables. I think I can do this by using system views likesys.db_dm_index_usagestats, physicalstats and operationalstats.I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etcI am wondering if ,Apart these views,...
View Answer
| Oct 8 2008 9:02 PM GMT
| asked by
Sqloholic
Indexes, SQL Server database, SQL Server tables
Storing general files in a SQL Server database
Is it wise to store files such as .doc's or .pdf's as binary objects in a SQL Server database? If there can be issues down the line, is there a way to design the SQL database to make it easier to work with?
View Answer
| Oct 8 2008 3:57 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server database design and modeling, SQL Server database
Producing a nightly tab delineated file for a SQL Server database
I wish to produce a nightly tab delineated file, based on a recordset, for our SQL Server database. How could I program this to be produced at a specific time each night?
View Answer
| Oct 8 2008 3:38 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server database
Connect SQL Server 2005 Express db to Visual Basic 2005 Express
I get an error "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances. I run the store procedure on SQL Server and it looks like it worked, but "Test Connection" gives me the same error. What can I do to resolve this error?
Answer Question
| Oct 3 2008 3:46 PM GMT
| asked by
Dhanson
SQL Server database, Visual Basic, VB 2005
Re-linking database user
Hi Guys,What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name.I am able to do this when I run the following command, and if the database user isn't the same as the login name.use tempalter user TestUser2 with name= TestUser2, login=...
View Answer
| Oct 1 2008 12:18 AM GMT
| asked by
Db23
SQL Server 2005, Alter user, SQL Server database
Using SQL Profiler to identify the cause of data loss
We have a SQL database where a table is having information vanish. We plan to use SQL Profiler to identify the cause of this sudden data loss. When using SQL Profiler, what counters should be captured? Also, what trace format should be used?
View Answer
| Sep 30 2008 5:42 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, SQL Server Profiler, SQL Server database
Truncating the transaction log for a SQL Server 2000 database
What is the best automated way to truncate the transaction log for a SQL Server 2000 database?
View Answer
| Sep 25 2008 7:05 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, SQL transaction logs, SQL Server database
Transferring a database from Microsoft Access to SQL Server 2000
How would I transfer a database from Microsoft Access to SQL Server 2000?
View Answer
| Sep 23 2008 6:09 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, Microsoft Access, SQL Server database
Connecting sql server 2000 to 2 databases simultaneously
I have to create a report to move inventory from an old warehouse to a new one. Each has a separate instance of the database, so I have to get the part# and location from the old warehouse and match it with the new location for that part# in the new warehouse. Is there a way to join tables from...
View Answer
| Sep 23 2008 3:33 PM GMT
| asked by
CO Bill
SQL Server 2000, SQL Server database
Re-applying column constraints
I have a 100+ db that was hacked. The column level constraints/defaults were removed. I'd like to know how I can reapply the constraints/defaults while keeping the data intact. I do have an identical database with no data in it.
View Answer
| Sep 23 2008 1:26 PM GMT
| asked by
Kcook
SQL Server 2005, SQL Server database restore, SQL Server database
SQL DATABASE SERVER
Hi,Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed in...
View Answer
| Sep 23 2008 7:03 AM GMT
| asked by
Chukbillo
SQL database, SQL Server Express, SQLEXPR
Archiving a row of data into another database on SQL Server 2005
I work on SQL Server 2005, and I need to archive a row and its relationship into another database. I know a script could be written to do this, but I would like to know if software exists that could be given the data row and then complete the archiving by itself. Is this possible?
View Answer
| Sep 16 2008 6:19 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Archiving, SQL Server archiving
securing sql server database object
I connect my access project to sql server. Is there as simple way to secure sql server object such as table, view, stored proc from editing or deletion since access let us to edit sql server object directly
View Answer
| Sep 15 2008 8:23 PM GMT
| asked by
Ipong
SQL Server security, SQL Server database, Microsoft Access
Creating database access at runtime for ADO and SQL Server
I’ve put together some code to create database access at runtime using an ADO database connection. How can I do the same for a SQL Server database?
View Answer
| Sep 11 2008 5:46 PM GMT
| asked by
SQL Server Ask the Experts
ADO, SQL Server database
Setting aside code for 12 databases in separate database on SQL Server
I have 12 databases on my SQL Server, one for each month of the year, and I have almost all the same stored procedures in each database. This architecture is hard to maintain, because you have duplication of the code, and a modification must be made on all the databases. Is there a way to put all...
View Answer
| Sep 8 2008 8:23 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Stored procedures, SQL Server database
Making a query for a SQL Server database
I would like to make a query for my SQL Server database to specify that only unmatching records should be displayed from both tables. Can you help me in doing so?
View Answer
| Sep 8 2008 8:14 PM GMT
| asked by
SQL Server Ask the Experts
Query, SQL Server database
Error message when connecting SQL Server database to ASP.NET
I’ve been getting the following message when connecting my SQL Server database to the ASP.NET application:"Login failed because, under default settings, SQL Server 2000 does not allow remote connections."What might this mean?
View Answer
| Sep 8 2008 8:12 PM GMT
| asked by
SQL Server Ask the Experts
ASP.NET, SQL Server errors, SQL Server database
Email notification in the event of a SQL Server database failover
In case of a failover of a SQL Server database, I’d like to be notified by email. Can you tell me how to activate this option?
View Answer
| Sep 2 2008 7:04 PM GMT
| asked by
SQL Server Ask the Experts
Failover, SQL Server database
Creating a website with a SQL Server database
What programming tools can I use to create a website that will be hosted on a Windows-based platform with a SQL Server database?
View Answer
| Aug 29 2008 4:01 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server database
