Storing and retrieving an image in SQL Server 2000
[kccrosser] I have to disagree with mrdenny – using SQL database table fields to store image blobs works quite well, and there are a lot of positive reasons to use this technique – not the least of which is the consistency of the database transactions and backups. As far as how to manipulate the data [...]
View Answer
| March 18, 2009 8:18 PM
SQL Server 2000, SQL Server Image Store, Visual Basic 6.0
[kccrosser] I have to disagree with mrdenny – using SQL database table fields to store image blobs works quite well, and there are a lot of positive reasons to use this technique – not the least of which is the consistency of the database transactions and backups. As far as how to manipulate the data [...]
View Answer
| March 18, 2009 8:18 PM
SQL Server 2000, SQL Server Image Store, Visual Basic 6.0
SQL to insert comma-delimited string value to table column
This question can’t be answered without more information. Which SQL server are you using? (MS SQL 2005, MySQL, SQLite, …) What platform is it running on? (PC, Linux, …) What application are you using to building your queries? (Visual Basic, C++, Access Query Builder, PHP, …) How is the string being stored? (Text file, Spread [...]
View Answer
| March 18, 2009 5:21 PM
Comma-delimited, SQL, SQL queries, SQL Server development, SQL Server Query
This question can’t be answered without more information. Which SQL server are you using? (MS SQL 2005, MySQL, SQLite, …) What platform is it running on? (PC, Linux, …) What application are you using to building your queries? (Visual Basic, C++, Access Query Builder, PHP, …) How is the string being stored? (Text file, Spread [...]
View Answer
| March 18, 2009 5:21 PM
Comma-delimited, SQL, SQL queries, SQL Server development, SQL Server Query
SQL Server 2005 log shipping network pass thru security
Setup a proxy for the local account and have the job step which does the file copy run under this proxy account. That “should” get it working.
View Answer
| March 18, 2009 2:30 AM
SQL Pass Through Query, SQL Server 2005, SQL Server 2005 log shipping, SQL Server Agent, SQL Server log shipping
Setup a proxy for the local account and have the job step which does the file copy run under this proxy account. That “should” get it working.
View Answer
| March 18, 2009 2:30 AM
SQL Pass Through Query, SQL Server 2005, SQL Server 2005 log shipping, SQL Server Agent, SQL Server log shipping
SQL Server 2005 Select Multiple views or Tables
Select tables from the tree view. Then in the Object Explorer Details window on the right (View > Object Explorer Details if it sin’t there) you can control select the objects you want to script out. Then right click and you should be able to script the objects out. You can do pretty much everything [...]
View Answer
| March 18, 2009 1:41 AM
SQL 2005, SQL Multiple Views, SQL Query Analyzer, SQL Server 2005, SQL tables
Select tables from the tree view. Then in the Object Explorer Details window on the right (View > Object Explorer Details if it sin’t there) you can control select the objects you want to script out. Then right click and you should be able to script the objects out. You can do pretty much everything [...]
View Answer
| March 18, 2009 1:41 AM
SQL 2005, SQL Multiple Views, SQL Query Analyzer, SQL Server 2005, SQL tables
SQL Server 2005 SP3 installation on Vista – error message
I think that Visual Studio 2005 SP 1 corrects this issue. If it doesn’t, just click thought the error and install the service pack. It normally works fine.
View Answer
| March 17, 2009 7:54 PM
SQL Server 2005, SQL Server 2005 SP3, SQL Server on Vista, SQL Server upgrades, Vista
I think that Visual Studio 2005 SP 1 corrects this issue. If it doesn’t, just click thought the error and install the service pack. It normally works fine.
View Answer
| March 17, 2009 7:54 PM
SQL Server 2005, SQL Server 2005 SP3, SQL Server on Vista, SQL Server upgrades, Vista
inserting null record in SQLServer2005 SSMEI through ASP.Net
The problem seems to be the construction of the INSERT statement. To debug the problem, I would display the <i>str</i> variable before executing the command, so you can see the command string that is going to be sent to the database. You could also try to execute that command directly against the database (from management [...]
View Answer
| March 17, 2009 7:07 PM
SQL Server 2005, SQL Server database
The problem seems to be the construction of the INSERT statement. To debug the problem, I would display the <i>str</i> variable before executing the command, so you can see the command string that is going to be sent to the database. You could also try to execute that command directly against the database (from management [...]
View Answer
| March 17, 2009 7:07 PM
SQL Server 2005, SQL Server database
SQL relational database
You could do something like this: SELECT e.EmployeeName FROM Employee e INNER JOIN Assignment a ON e.EmployeeNo=a.EMployeeNo INNER JOIN Project p ON p.ProjectNo=a.ProjectNo WHERE p.ProjectName=’_specific_projectname_’ ORDER BY e.EmployeeName If you’re looking for all employees for all existing projects, then: SELECT p.ProjectName,e.EmployeeName FROM Employee e INNER JOIN Assignment a ON e.EmployeeNo=a.EMployeeNo INNER JOIN Project p ON [...]
View Answer
| March 17, 2009 2:25 PM
SQL queries, SQL relational database
You could do something like this: SELECT e.EmployeeName FROM Employee e INNER JOIN Assignment a ON e.EmployeeNo=a.EMployeeNo INNER JOIN Project p ON p.ProjectNo=a.ProjectNo WHERE p.ProjectName=’_specific_projectname_’ ORDER BY e.EmployeeName If you’re looking for all employees for all existing projects, then: SELECT p.ProjectName,e.EmployeeName FROM Employee e INNER JOIN Assignment a ON e.EmployeeNo=a.EMployeeNo INNER JOIN Project p ON [...]
View Answer
| March 17, 2009 2:25 PM
SQL queries, SQL relational database
SQL Server 2008: SSIS pakage with parameters
Declare the variable as a package level variable. Then put some code in a script task which checks the value of the varabile. If the value is the default value that you set when you created the variable use the InputBox function in .NET to prompt the user to enter a value.
View Answer
| March 17, 2009 12:39 AM
SQL Server 2008, SSIS Package, SSIS Package 2008
Declare the variable as a package level variable. Then put some code in a script task which checks the value of the varabile. If the value is the default value that you set when you created the variable use the InputBox function in .NET to prompt the user to enter a value.
View Answer
| March 17, 2009 12:39 AM
SQL Server 2008, SSIS Package, SSIS Package 2008
Error while referencing external assembly in SQL Server 2005.
Does the assembly exist at the path specified on the SQL Server? You’d be better off placing the assembly in the GAC then calling it from there. What is the end goal of this assembly?
View Answer
| March 16, 2009 7:22 PM
.NET Framework 3.5, Database programming, SQL Server 2005, SQL Server development, Visual Studio 2008, WCFServiceLibrary
Does the assembly exist at the path specified on the SQL Server? You’d be better off placing the assembly in the GAC then calling it from there. What is the end goal of this assembly?
View Answer
| March 16, 2009 7:22 PM
.NET Framework 3.5, Database programming, SQL Server 2005, SQL Server development, Visual Studio 2008, WCFServiceLibrary
Finding a table’s name from a trigger name in SQL Server
You could use a query like this: <pre>SELECT name as table_name FROM sys.all_objects WHERE type = ‘U’ AND object_id = ( SELECT parent_object_id FROM sys.all_objects WHERE type = ‘TR’ and name = ‘YourTriggerName’);</pre> ——— <pre>SELECT object_name(parent_id), name FROM sys.triggers WHERE name = ‘YourTriggerName’</pre>
View Answer
| March 16, 2009 7:16 PM
SQL Server, SQL Server tables, SQL Server triggers
You could use a query like this: <pre>SELECT name as table_name FROM sys.all_objects WHERE type = ‘U’ AND object_id = ( SELECT parent_object_id FROM sys.all_objects WHERE type = ‘TR’ and name = ‘YourTriggerName’);</pre> ——— <pre>SELECT object_name(parent_id), name FROM sys.triggers WHERE name = ‘YourTriggerName’</pre>
View Answer
| March 16, 2009 7:16 PM
SQL Server, SQL Server tables, SQL Server triggers
Attaching a SQL Server 2005 database to SQL Server 2000
You can’t attach a SQL Server 2005 database to a SQL 2000 server. You will need to script out the tables, procedures, etc adn then create them in the SQL 2000 server, then use SSIS or DTS to copy the data from the SQL 2005 server to the SQL 2000 server.
View Answer
| March 16, 2009 7:15 PM
SQL Server 2000, SQL Server 2005, SQL Server 2005 Database, SQL Server databases
You can’t attach a SQL Server 2005 database to a SQL 2000 server. You will need to script out the tables, procedures, etc adn then create them in the SQL 2000 server, then use SSIS or DTS to copy the data from the SQL 2005 server to the SQL 2000 server.
View Answer
| March 16, 2009 7:15 PM
SQL Server 2000, SQL Server 2005, SQL Server 2005 Database, SQL Server databases
Unable to correctly view overlapping SQL Server tables
Because of the way HTML is rendered there are a few cases where this will happen. You can submit the bug to Microsoft via the connect.microsoft.com site and see what they say about correcting the problem.
View Answer
| March 16, 2009 7:14 PM
SQL Server, SQL Server Report View, SQL Server tables
Because of the way HTML is rendered there are a few cases where this will happen. You can submit the bug to Microsoft via the connect.microsoft.com site and see what they say about correcting the problem.
View Answer
| March 16, 2009 7:14 PM
SQL Server, SQL Server Report View, SQL Server tables
Possible to deploy 2005 report to sql 2000 RS?
I don’t think so. I believe that the RDL format changed between SQL 2000 and SQL 2005, and so the SQL 2000 server won’t know what to do with the SQL 2005 RDL file.
View Answer
| March 14, 2009 6:26 AM
SQL Server 2000, SQL Server Reports, SSRS, SSRS 2000, Visual Studio, Visual Studio 2005, VS 2005
I don’t think so. I believe that the RDL format changed between SQL 2000 and SQL 2005, and so the SQL 2000 server won’t know what to do with the SQL 2005 RDL file.
View Answer
| March 14, 2009 6:26 AM
SQL Server 2000, SQL Server Reports, SSRS, SSRS 2000, Visual Studio, Visual Studio 2005, VS 2005
SQL Server replication fails after renaming Subscriber database
No, you can’t rename the subscriber database. If you need to you can update the subscribers table in the distributor. You would also need to change the distribution job so that it has the new subscriber name.
View Answer
| March 14, 2009 6:23 AM
SQL Server 2005, SQL Server 2005 replication, SQL Server Publisher/Subscriber, SQL Server replication, Windows Server 2003
No, you can’t rename the subscriber database. If you need to you can update the subscribers table in the distributor. You would also need to change the distribution job so that it has the new subscriber name.
View Answer
| March 14, 2009 6:23 AM
SQL Server 2005, SQL Server 2005 replication, SQL Server Publisher/Subscriber, SQL Server replication, Windows Server 2003
Crystal Reports last twelve months
A simple way in Crystal, I am assuming that the report date is restricted to a single full year, then: Make a formula extracting the month from the date field – MONTH(Subtotal) Then make a formula for each month – if {@Month} = 1 then {Subtotal} else 0 – do this for each month. Alternative [...]
View Answer
| March 13, 2009 4:36 PM
Crystal Reports, SQL Database, SQL queries
A simple way in Crystal, I am assuming that the report date is restricted to a single full year, then: Make a formula extracting the month from the date field – MONTH(Subtotal) Then make a formula for each month – if {@Month} = 1 then {Subtotal} else 0 – do this for each month. Alternative [...]
View Answer
| March 13, 2009 4:36 PM
Crystal Reports, SQL Database, SQL queries
Transform Data task properties not opening.
I believe I am having the SAME problem. At first I thought it was related to installing Internet Explorer 7 or SQL Server 2005 tools. However, I think I’ve disproved that theory. Now I’m fairly confident – but unable to prove that this is related to installation of Windows XP SP3…! I’d be curious if [...]
View Answer
| March 10, 2009 10:59 PM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task
I believe I am having the SAME problem. At first I thought it was related to installing Internet Explorer 7 or SQL Server 2005 tools. However, I think I’ve disproved that theory. Now I’m fairly confident – but unable to prove that this is related to installation of Windows XP SP3…! I’d be curious if [...]
View Answer
| March 10, 2009 10:59 PM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task
Reporting and Mirrored SQL2005 DB
No, the mirrored database is not available for reading. You would need to run your reports off of the active server.
View Answer
| March 10, 2009 8:25 PM
Crystal Reports, SQL 2005, SQL 2005 Database, SQL Database, SQL Server Database Mirroring
No, the mirrored database is not available for reading. You would need to run your reports off of the active server.
View Answer
| March 10, 2009 8:25 PM
Crystal Reports, SQL 2005, SQL 2005 Database, SQL Database, SQL Server Database Mirroring
Allocated Memory Alert
If SQL Server isn’t being used by anything disable it. Like all other services you should only be running the ones that you need otherwise you are wasting system resources and getting no benefit.
View Answer
| March 10, 2009 8:08 PM
SBS 2003, SBS 2003 R2, SBS Allocated Memory Alert, SBS Installation, SBS Performance, SQL Server
If SQL Server isn’t being used by anything disable it. Like all other services you should only be running the ones that you need otherwise you are wasting system resources and getting no benefit.
View Answer
| March 10, 2009 8:08 PM
SBS 2003, SBS 2003 R2, SBS Allocated Memory Alert, SBS Installation, SBS Performance, SQL Server
SQL 2000 db transactions/sec
That all depends on how complex the transacations are and how well indexed the tables are. If the tables aren’t indexed correctly and the transactions are complex then a couple of hundred per second may be to many. If the tables are well indexed and the transactions are small and simply then thousands could be [...]
View Answer
| March 9, 2009 9:09 PM
SQL Server 2000, SQL Server database, SQL Server Database Transactions, SQL Server performance, SQL Server performance tuning, Windows Server 2003
That all depends on how complex the transacations are and how well indexed the tables are. If the tables aren’t indexed correctly and the transactions are complex then a couple of hundred per second may be to many. If the tables are well indexed and the transactions are small and simply then thousands could be [...]
View Answer
| March 9, 2009 9:09 PM
SQL Server 2000, SQL Server database, SQL Server Database Transactions, SQL Server performance, SQL Server performance tuning, Windows Server 2003
How many tempdb’s necessary in our clustered environment?
Each instance of SQL Server has its own tempdb database. Each tempdb database should have one file for each CPU core that it will be using. If each node has 8 CPU cores then each tempdb should be setup with 8 files.
View Answer
| March 9, 2009 9:04 PM
Clustered servers, SQL Server clustering, TempDBs
Each instance of SQL Server has its own tempdb database. Each tempdb database should have one file for each CPU core that it will be using. If each node has 8 CPU cores then each tempdb should be setup with 8 files.
View Answer
| March 9, 2009 9:04 PM
Clustered servers, SQL Server clustering, TempDBs
