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 temp alter user TestUser2 [...]
Answer Question
| October 2, 2008 12:18 PM
Alter user, SQL Server 2005, SQL Server database
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 temp alter user TestUser2 [...]
Answer Question
| October 2, 2008 12:18 PM
Alter user, SQL Server 2005, 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?
Answer Question
| September 30, 2008 5:42 PM
SQL Server, SQL Server database, SQL Server Profiler
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?
Answer Question
| September 30, 2008 5:42 PM
SQL Server, SQL Server database, SQL Server Profiler
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?
Answer Question
| September 25, 2008 7:05 PM
SQL Server 2000, SQL Server database, SQL transaction logs
What is the best automated way to truncate the transaction log for a SQL Server 2000 database?
Answer Question
| September 25, 2008 7:05 PM
SQL Server 2000, SQL Server database, SQL transaction logs
Transferring a database from Microsoft Access to SQL Server 2000
How would I transfer a database from Microsoft Access to SQL Server 2000?
Answer Question
| September 23, 2008 6:09 PM
Access Database, Microsoft Access, SQL Server 2000, SQL Server database
How would I transfer a database from Microsoft Access to SQL Server 2000?
Answer Question
| September 23, 2008 6:09 PM
Access Database, Microsoft Access, SQL Server 2000, 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 [...]
Answer Question
| September 24, 2008 3:33 PM
SQL Server 2000, SQL Server database
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 [...]
Answer Question
| September 24, 2008 3:33 PM
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.
Answer Question
| September 26, 2008 1:26 PM
SQL Server 2005, SQL Server database, SQL Server database restore
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.
Answer Question
| September 26, 2008 1:26 PM
SQL Server 2005, SQL Server database, SQL Server database restore
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 my PC but [...]
Answer Question
| September 23, 2008 7:03 AM
SQL Database, SQL Server 9.x, SQL Server database, SQL Server Express, SQLEXPR
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 my PC but [...]
Answer Question
| September 23, 2008 7:03 AM
SQL Database, SQL Server 9.x, SQL Server 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?
Answer Question
| September 16, 2008 6:19 PM
Archiving, SQL Server 2005, SQL Server archiving, SQL Server database
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?
Answer Question
| September 16, 2008 6:19 PM
Archiving, SQL Server 2005, SQL Server archiving, SQL Server database
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
Answer Question
| September 15, 2008 8:23 PM
Microsoft Access, SQL Server database, SQL Server security
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
Answer Question
| September 15, 2008 8:23 PM
Microsoft Access, SQL Server database, SQL Server security
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?
Answer Question
| September 20, 2008 5:46 PM
ADO, SQL Server database
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?
Answer Question
| September 20, 2008 5:46 PM
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 [...]
Answer Question
| September 9, 2008 8:23 PM
SQL Server, SQL Server database, Stored Procedures
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 [...]
Answer Question
| September 9, 2008 8:23 PM
SQL Server, SQL Server database, Stored Procedures
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?
Answer Question
| September 8, 2008 8:14 PM
Query, 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?
Answer Question
| September 8, 2008 8:14 PM
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?
Answer Question
| September 9, 2008 8:12 PM
ASP.NET, SQL Server database, SQL Server errors
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?
Answer Question
| September 9, 2008 8:12 PM
ASP.NET, SQL Server database, SQL Server errors
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?
Answer Question
| September 3, 2008 7:04 PM
Failover, SQL Server database
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?
Answer Question
| September 3, 2008 7:04 PM
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?
Answer Question
| August 29, 2008 4:01 PM
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?
Answer Question
| August 29, 2008 4:01 PM
SQL Server database
Union Query
I ‘ve a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a. parameterized query to filter each [...]
Answer Question
| September 1, 2008 6:27 PM
Access Database, Microsoft Access, SQL Server database, SQL Server stored procedures
I ‘ve a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a. parameterized query to filter each [...]
Answer Question
| September 1, 2008 6:27 PM
Access Database, Microsoft Access, SQL Server database, SQL Server stored procedures
Copying a database to a newer version of SQL Server
I have a database on my SQL Server that needs to be upgraded to SQL Server 2005 or SQL Server 2008, but when I try to copy it with the Copy Database Wizard, I do not have the option “Copy” listed under “Tasks”. I am using SQL Server Express, which I think may be my [...]
Answer Question
| August 19, 2008 7:01 PM
Copy Database Wizard, SQL Server database
I have a database on my SQL Server that needs to be upgraded to SQL Server 2005 or SQL Server 2008, but when I try to copy it with the Copy Database Wizard, I do not have the option “Copy” listed under “Tasks”. I am using SQL Server Express, which I think may be my [...]
Answer Question
| August 19, 2008 7:01 PM
Copy Database Wizard, SQL Server database
Recovering a deleted database in SQL Server 2005
I’ve accidentally deleted a database on SQL Server 2005, and I do not have a backup. Is there any way to recover it?
Answer Question
| August 20, 2008 6:38 PM
Recovery, SQL Server 2005, SQL Server database
I’ve accidentally deleted a database on SQL Server 2005, and I do not have a backup. Is there any way to recover it?
Answer Question
| August 20, 2008 6:38 PM
Recovery, SQL Server 2005, SQL Server database
Copying a database from SQL Server 2000 to SQL Server 2005
I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package (“Access to the path ‘SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLDatactyis_before_migrate_data.mdf’ [...]
Answer Question
| August 11, 2008 4:03 PM
SQL Server 2000, SQL Server 2005, SQL Server database
I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package (“Access to the path ‘SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLDatactyis_before_migrate_data.mdf’ [...]
Answer Question
| August 11, 2008 4:03 PM
SQL Server 2000, SQL Server 2005, SQL Server database
Database hanged due to concurrence
Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration issue? What should we check [...]
Answer Question
| August 11, 2008 5:40 PM
Database performance and tuning, SQL Server 2000, SQL Server database, Windows Server 2003
Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration issue? What should we check [...]
Answer Question
| August 11, 2008 5:40 PM
Database performance and tuning, SQL Server 2000, SQL Server database, Windows Server 2003
