Passing a database name as a stored procedure parameter
I would like to be able to pass the name of a database as a parameter to a stored procedure. This db would be used for certain queries and may be different from the db where the stored procedure runs. Is it possible to specify a database name from within the T-SQL of the stored [...]
Answer Question
| March 12, 2008 10:13 PM
Stored Procedures, T-SQL
I would like to be able to pass the name of a database as a parameter to a stored procedure. This db would be used for certain queries and may be different from the db where the stored procedure runs. Is it possible to specify a database name from within the T-SQL of the stored [...]
Answer Question
| March 12, 2008 10:13 PM
Stored Procedures, T-SQL
Do you have to break the replication after you install a service pack in SQL Server 2005?
In SQL Server 2005 when you install a service pack – do you have to break the replication as you did in SQL Server 2000 – and then reestablish the replication?
Answer Question
| March 12, 2008 10:08 PM
SQL Server installation, SQL Server replication, SQL Server upgrades
In SQL Server 2005 when you install a service pack – do you have to break the replication as you did in SQL Server 2000 – and then reestablish the replication?
Answer Question
| March 12, 2008 10:08 PM
SQL Server installation, SQL Server replication, SQL Server upgrades
Setting up database mirroring for disaster recovery in SQL Server
I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, [...]
Answer Question
| March 12, 2008 10:04 PM
Database mirroring, Disaster Recovery, High Availability, SQL Server 2000, SQL Server 2005
I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, [...]
Answer Question
| March 12, 2008 10:04 PM
Database mirroring, Disaster Recovery, High Availability, SQL Server 2000, SQL Server 2005
Merge Replication Identity Ranges
What should the publication range and subscription range be set to for each table with identity ranges, bearing in mind thousands of changes can go into some tables each day. I have 1 Publisher and 9 Subscriptions (Merge) and have started getting “The Publisher failed to allocate a new set of identity ranges for the [...]
Answer Question
| March 11, 2008 4:41 PM
Merge replication, Replication, SQL Server 2005, SQL Server administration
What should the publication range and subscription range be set to for each table with identity ranges, bearing in mind thousands of changes can go into some tables each day. I have 1 Publisher and 9 Subscriptions (Merge) and have started getting “The Publisher failed to allocate a new set of identity ranges for the [...]
Answer Question
| March 11, 2008 4:41 PM
Merge replication, Replication, SQL Server 2005, SQL Server administration
Connectiveity JAVA to Sql server 2000
Dear all, I have problam to connect SQL 2000 server with jdbc driver. i m using windows 2003 server SQL server 200000 and jbuilder. anyone have jdbc driver for the same environment thnaks
Answer Question
| March 11, 2008 6:02 AM
JDBC, SQL Server 2000, Windows Server 2003
Dear all, I have problam to connect SQL 2000 server with jdbc driver. i m using windows 2003 server SQL server 200000 and jbuilder. anyone have jdbc driver for the same environment thnaks
Answer Question
| March 11, 2008 6:02 AM
JDBC, SQL Server 2000, Windows Server 2003
Encrypt a Column in sql server 2005
I’m trying to encrypt a column. Unfortunately I don’t have access to the C# source code that is accessing the data. All the instructions I’ve found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is it possible? [...]
Answer Question
| March 10, 2008 4:39 PM
SQL, SQL Server, SQL Server 2005, SQL Server security
I’m trying to encrypt a column. Unfortunately I don’t have access to the C# source code that is accessing the data. All the instructions I’ve found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is it possible? [...]
Answer Question
| March 10, 2008 4:39 PM
SQL, SQL Server, SQL Server 2005, SQL Server security
Restoring a SQL Server 2005 IBM Rational RequisitePro database from SQL Server 2008, back to SQL Server 2005
I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.
Answer Question
| March 7, 2008 10:47 PM
SQL Server 2005, SQL Server 2008, SQL Server database restore
I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.
Answer Question
| March 7, 2008 10:47 PM
SQL Server 2005, SQL Server 2008, SQL Server database restore
How can we reindex a SQL Server 2000 database?
We have a SQL Server 2000 database that has never been reindexed. Do you have any suggestions? Is there a link to a step-by-step process for SQL Server database reindexeing you can share?
Answer Question
| March 7, 2008 10:29 PM
SQL Server 2000, SQL Server database design and modeling
We have a SQL Server 2000 database that has never been reindexed. Do you have any suggestions? Is there a link to a step-by-step process for SQL Server database reindexeing you can share?
Answer Question
| March 7, 2008 10:29 PM
SQL Server 2000, SQL Server database design and modeling
How can I bring a .dat database file into SQL Server 2005?
I need to bring a .dat database into SQL Server 2005. When I right click on database and Task, I don’t get the “Copy Database” option. What do I need to have this? What is an alternative method to bring the SQL Server 2000 database into SQL Server 2005 Express?
Answer Question
| March 7, 2008 10:26 PM
SQL Server 2000, SQL Server 2005
I need to bring a .dat database into SQL Server 2005. When I right click on database and Task, I don’t get the “Copy Database” option. What do I need to have this? What is an alternative method to bring the SQL Server 2000 database into SQL Server 2005 Express?
Answer Question
| March 7, 2008 10:26 PM
SQL Server 2000, SQL Server 2005
Is it possible for named instances to share components in SQL Server 2005?
Is it possible for two named instances to share components in SQL Server 2005? I’m aware multiple instances have their own components, but is there any way these can be shared to reduce overhead in SQL Server?
Answer Question
| March 7, 2008 10:22 PM
SQL Server 2005
Is it possible for two named instances to share components in SQL Server 2005? I’m aware multiple instances have their own components, but is there any way these can be shared to reduce overhead in SQL Server?
Answer Question
| March 7, 2008 10:22 PM
SQL Server 2005
sql 2005 db security for public
I have databases that were converted (by restore) from sql 2000 to sql 2005. I found a script to move the logins (all using nt/sql auth) to the 2005 box. All the users on the sql 2000 box belonged to public on the old box. If i loook at the users inside the db’s on [...]
Answer Question
| March 6, 2008 10:07 PM
SQL Server 2000, SQL Server 2005, SQL Server security
I have databases that were converted (by restore) from sql 2000 to sql 2005. I found a script to move the logins (all using nt/sql auth) to the 2005 box. All the users on the sql 2000 box belonged to public on the old box. If i loook at the users inside the db’s on [...]
Answer Question
| March 6, 2008 10:07 PM
SQL Server 2000, SQL Server 2005, SQL Server security
Apache config question
I’m trying to get a rewriteCond & rewriteRule to work. I want the command to check for a file(image) and if it doesn’t find it to use a default image. Not having any luck getting the command right. example: RewriteCond /doc/route/%{REQUEST_FILENAME} !-f RewriteRule ^(.+) /dir/images/dir/00000000.JPG [L]
Answer Question
| March 5, 2008 4:24 PM
Apache, Config, Web
I’m trying to get a rewriteCond & rewriteRule to work. I want the command to check for a file(image) and if it doesn’t find it to use a default image. Not having any luck getting the command right. example: RewriteCond /doc/route/%{REQUEST_FILENAME} !-f RewriteRule ^(.+) /dir/images/dir/00000000.JPG [L]
Answer Question
| March 5, 2008 4:24 PM
Apache, Config, Web
SQL Right Trim Nulls
How can I trim any trailng nulls from a selected record set. I have a table with up to 17 cols that I need to extract data from which included all embedded nulls but no trailing nulls
Answer Question
| March 5, 2008 3:01 PM
Nulls, SQL, TRIM function
How can I trim any trailng nulls from a selected record set. I have a table with up to 17 cols that I need to extract data from which included all embedded nulls but no trailing nulls
Answer Question
| March 5, 2008 3:01 PM
Nulls, SQL, TRIM function
Installing Terminal server to existing domain
I have a client who has Server 2003 R2 installed running 2 line of business applications on SQL Express databases, plus Exchange. They have installed a Second server as a Terminal Server to provide access for remote workers. Do I have to reinstall the applications on the Terminal Server, or is there a way to [...]
Answer Question
| March 5, 2008 7:07 AM
Exchange, SQL Express, Terminal Server, Windows Server 2003
I have a client who has Server 2003 R2 installed running 2 line of business applications on SQL Express databases, plus Exchange. They have installed a Second server as a Terminal Server to provide access for remote workers. Do I have to reinstall the applications on the Terminal Server, or is there a way to [...]
Answer Question
| March 5, 2008 7:07 AM
Exchange, SQL Express, Terminal Server, Windows Server 2003
issue sp_helprotect
if i give sp_helprotect on one table. it shows the list of access few tables permissions including given table. can i know why it is happens
Answer Question
| December 23, 2008 3:01 AM
sp_helprotect, T-SQL
if i give sp_helprotect on one table. it shows the list of access few tables permissions including given table. can i know why it is happens
Answer Question
| December 23, 2008 3:01 AM
sp_helprotect, T-SQL
How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?
How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?
Answer Question
| March 5, 2008 11:39 PM
SQL Server, Stored Procedures
How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?
Answer Question
| March 5, 2008 11:39 PM
SQL Server, Stored Procedures
In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?
In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?
Answer Question
| April 21, 2008 11:36 PM
SQL Server 2005, SQL Server administration
In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?
Answer Question
| April 21, 2008 11:36 PM
SQL Server 2005, SQL Server administration
Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?
Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?
Answer Question
| March 5, 2008 11:33 PM
SQL Server 2005, Windows Server 2003
Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?
Answer Question
| March 5, 2008 11:33 PM
SQL Server 2005, Windows Server 2003
Equivolent SQL Server function for Access DoCmd.TransferText
I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?
Answer Question
| March 5, 2008 4:36 PM
DoCmd.Transfer, Microsoft Access, SQL Server, Stored Procedures
I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?
Answer Question
| March 5, 2008 4:36 PM
DoCmd.Transfer, Microsoft Access, SQL Server, Stored Procedures
execution plan is same even though it takes 10 times longer to run
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!
Answer Question
| March 10, 2008 5:07 AM
Execution Plan, Indexes, Performance/Tuning
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!
Answer Question
| March 10, 2008 5:07 AM
Execution Plan, Indexes, Performance/Tuning
