Storing BLOB to file through SQL Server 2005
SQL Server will only give you the raw binary data. In theory you can take this data, and save it to a file with the JPG extension and it should be a valid JPG. Using a C#.NET or VB.NET application will be your best bet.
View Answer
| May 2, 2008 2:06 AM
BLOB, Database, SQL Server 2005
SQL Server will only give you the raw binary data. In theory you can take this data, and save it to a file with the JPG extension and it should be a valid JPG. Using a C#.NET or VB.NET application will be your best bet.
View Answer
| May 2, 2008 2:06 AM
BLOB, Database, SQL Server 2005
How to use partitioning in SQL Server database to avoid ‘timeout’ errors
If you are using SQL Server 2000, you have to create new tables broken out by year, then manually move the data into those new tables. Then modify your code to search these tables. If you are using SQL Server 2005 you can create a partitioned table, then move the data into the table. The [...]
View Answer
| May 2, 2008 1:47 AM
Partitions, SQL error messages, SQL Server performance tuning, Timeout
If you are using SQL Server 2000, you have to create new tables broken out by year, then manually move the data into those new tables. Then modify your code to search these tables. If you are using SQL Server 2005 you can create a partitioned table, then move the data into the table. The [...]
View Answer
| May 2, 2008 1:47 AM
Partitions, SQL error messages, SQL Server performance tuning, Timeout
Using shell execute from Visual Basic
In general, you can run Shell commands with code like: <pre>’ Assume a string called shellCommand Dim wshShell as Object Set aWshShell = WScript.CreateObject(“WScript.Shell”) aWshShell.Exec shellCommand</pre> You can more information on Exec at <a href=”http://msdn.microsoft.com/en-us/library/ateytk4a(VS.85).aspx”>Microsoft’s WshShell.Exec reference for VBA</a>.
View Answer
| May 1, 2008 1:33 PM
Microsoft Access, Oracle, ShellExecute, SQL Loader, Visual Basic
In general, you can run Shell commands with code like: <pre>’ Assume a string called shellCommand Dim wshShell as Object Set aWshShell = WScript.CreateObject(“WScript.Shell”) aWshShell.Exec shellCommand</pre> You can more information on Exec at <a href=”http://msdn.microsoft.com/en-us/library/ateytk4a(VS.85).aspx”>Microsoft’s WshShell.Exec reference for VBA</a>.
View Answer
| May 1, 2008 1:33 PM
Microsoft Access, Oracle, ShellExecute, SQL Loader, Visual Basic
Online Masters degree in Networking and System Administration
There are lots of schools offering online degree programs in IT/IS as well as other majors, particularly at the graduate level. It should not be difficult finding a non-programming track right here in the U.S. The most important thing is making sure that a school is accredited by a widely recognized accreditation body. The following [...]
View Answer
| May 1, 2008 2:33 AM
Career development, IT careers, Training
There are lots of schools offering online degree programs in IT/IS as well as other majors, particularly at the graduate level. It should not be difficult finding a non-programming track right here in the U.S. The most important thing is making sure that a school is accredited by a widely recognized accreditation body. The following [...]
View Answer
| May 1, 2008 2:33 AM
Career development, IT careers, Training
What do I need to do to be a network architect?
One of the most important things you will need is experience. Getting to be an architect at that level takes years of network administration and engineering experience. Starting as a network administrator is an excellent starting point in getting to your goal of being a network architect. Dear NetworkATE: Thanks for submitting another question. The [...]
View Answer
| April 30, 2008 4:51 PM
CCNA, Certifications, IT careers, IT jobs, Network architecture, Network design, Networking
One of the most important things you will need is experience. Getting to be an architect at that level takes years of network administration and engineering experience. Starting as a network administrator is an excellent starting point in getting to your goal of being a network architect. Dear NetworkATE: Thanks for submitting another question. The [...]
View Answer
| April 30, 2008 4:51 PM
CCNA, Certifications, IT careers, IT jobs, Network architecture, Network design, Networking
access 07 help
what ever you want other peoples to do either update or register just share that particular document and then person is through. note: you must have a software that reguires login and log out okay ?
View Answer
| April 30, 2008 2:32 PM
Access 2007, Database, Microsoft Access
what ever you want other peoples to do either update or register just share that particular document and then person is through. note: you must have a software that reguires login and log out okay ?
View Answer
| April 30, 2008 2:32 PM
Access 2007, Database, Microsoft Access
MS ACCESS 2007 mass email list?
First, make an email group in Outlook with all the addresses that you want the mass mailing to go to. Then, in Access, use the Docmd.SendObject method and specify the query or table as the object to send, the format to send it in (Excel would probably be the best) and the email group that [...]
View Answer
| April 30, 2008 1:47 PM
Access 2007, Mailing lists, Microsoft Access, Microsoft Office 2007, Outlook
First, make an email group in Outlook with all the addresses that you want the mass mailing to go to. Then, in Access, use the Docmd.SendObject method and specify the query or table as the object to send, the format to send it in (Excel would probably be the best) and the email group that [...]
View Answer
| April 30, 2008 1:47 PM
Access 2007, Mailing lists, Microsoft Access, Microsoft Office 2007, Outlook
I need help with how to programmatically backup a database
read the log file is the unique way to verify wheter the export was successfull or not. You can write a second script to read the log file.
View Answer
| April 29, 2008 7:44 PM
Database, Oracle, Oracle backup
read the log file is the unique way to verify wheter the export was successfull or not. You can write a second script to read the log file.
View Answer
| April 29, 2008 7:44 PM
Database, Oracle, Oracle backup
Moving a SQL database from one host to another
Does the current hosting provider offer you a way to backup the database, and get access to that backup? What sort of access to the SQL Server do you have? Do you have to use thier web based tool, or can you connect directly to the SQL Server using the native SQL Server tools? The [...]
View Answer
| April 29, 2008 5:18 PM
ASP, Database migration, SQL, SQL Database, VBScript, Web development
Does the current hosting provider offer you a way to backup the database, and get access to that backup? What sort of access to the SQL Server do you have? Do you have to use thier web based tool, or can you connect directly to the SQL Server using the native SQL Server tools? The [...]
View Answer
| April 29, 2008 5:18 PM
ASP, Database migration, SQL, SQL Database, VBScript, Web development
Running Procedures within the PL/SQL program
I might be missing a few details, but to execute another stored procedure inside a stored procedure, simply call the procedure with its parameters procedure1(parameter1,parameter2,…); Whether or not it needs to be in a cursor, depends on what the procedure does. If the cursor does not return a lot of rows ( less than a [...]
View Answer
| April 28, 2008 2:07 PM
EXEC, PL/SQL, SQL Server stored procedures, Stored Procedures
I might be missing a few details, but to execute another stored procedure inside a stored procedure, simply call the procedure with its parameters procedure1(parameter1,parameter2,…); Whether or not it needs to be in a cursor, depends on what the procedure does. If the cursor does not return a lot of rows ( less than a [...]
View Answer
| April 28, 2008 2:07 PM
EXEC, PL/SQL, SQL Server stored procedures, Stored Procedures
Suggestions needed on continuing my Information Security Career
Wow… well if you were really involved in the ISO27001:2005 certification for your organization, you should have a broad understanding of infosec. Were there any particular areas of ISO27001 that caught your interest? There are certifications like <a href=”http://certification.comptia.org/security/default.aspx”>CompTia’s Security+</a>, or CISSP or CISM from <a href=”https://www.isc2.org/cgi-bin/index.cgi”>ISC2</a>. Another option to understand the technology and thought [...]
View Answer
| April 28, 2008 12:50 PM
Career in Information Security, Certifications, IT careers
Wow… well if you were really involved in the ISO27001:2005 certification for your organization, you should have a broad understanding of infosec. Were there any particular areas of ISO27001 that caught your interest? There are certifications like <a href=”http://certification.comptia.org/security/default.aspx”>CompTia’s Security+</a>, or CISSP or CISM from <a href=”https://www.isc2.org/cgi-bin/index.cgi”>ISC2</a>. Another option to understand the technology and thought [...]
View Answer
| April 28, 2008 12:50 PM
Career in Information Security, Certifications, IT careers
How to pass a Whereclause from a form to another form’s subform in Access 2000?
You can use the openargs parameter of the OpenForm method to pass in the strWhere string. In FormB, use the OnOpen event to get the parameter passed in by referencing me.openargs. Then set the subforms filter property with the where string. ex. for FormB Sub Form_Open me!subform.form.filter = me.openargs me!subform.form.filteron = true End sub or [...]
View Answer
| April 25, 2008 8:22 PM
Microsoft Access
You can use the openargs parameter of the OpenForm method to pass in the strWhere string. In FormB, use the OnOpen event to get the parameter passed in by referencing me.openargs. Then set the subforms filter property with the where string. ex. for FormB Sub Form_Open me!subform.form.filter = me.openargs me!subform.form.filteron = true End sub or [...]
View Answer
| April 25, 2008 8:22 PM
Microsoft Access
bulk update in sql server 2005
In SQL Server, if you are referening multiple tables in an UPDATE statement with a FROM clause, you need to include a reference to the table being updated in the FROM clause. <pre>UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableA INNER JOIN TableB ON TableA.A3 = TableA.B3</pre> or <pre>UPDATE TableA SET TableA.A1 [...]
View Answer
| April 25, 2008 5:21 PM
BULK UPDATE, SQL Server 2005
In SQL Server, if you are referening multiple tables in an UPDATE statement with a FROM clause, you need to include a reference to the table being updated in the FROM clause. <pre>UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableA INNER JOIN TableB ON TableA.A3 = TableA.B3</pre> or <pre>UPDATE TableA SET TableA.A1 [...]
View Answer
| April 25, 2008 5:21 PM
BULK UPDATE, SQL Server 2005
Network design and infrastructure for a small business with on-site and remote access workers
Get a VNP device that supports software connections and install this on the laptops. This way remote users can VPN to the main office from anywhere. I believe Watchguard and SonicWall both provide this type of setup at a reasonable price point. You could also use Citrix/Terminal Server to allow remote users to get at [...]
View Answer
| April 25, 2008 2:32 PM
Database, Digital Private Circuit, Internet service providers, ISPs, Network design, Network infrastructure, Project management, Remote access, Servers, Small business (smb) technology projects, Small businesses, SMB, Storage
Get a VNP device that supports software connections and install this on the laptops. This way remote users can VPN to the main office from anywhere. I believe Watchguard and SonicWall both provide this type of setup at a reasonable price point. You could also use Citrix/Terminal Server to allow remote users to get at [...]
View Answer
| April 25, 2008 2:32 PM
Database, Digital Private Circuit, Internet service providers, ISPs, Network design, Network infrastructure, Project management, Remote access, Servers, Small business (smb) technology projects, Small businesses, SMB, Storage
SQL 2005 error code = 80004003: Invalid Pointer
Can you query the tables from with the SQL Server Management tools? Can you use the management tools locally? Remotely?
View Answer
| April 24, 2008 10:57 PM
Database, Servers, SQL, SQL Server 2005
Can you query the tables from with the SQL Server Management tools? Can you use the management tools locally? Remotely?
View Answer
| April 24, 2008 10:57 PM
Database, Servers, SQL, SQL Server 2005
Bulk update in SQL Server 2005
Assuming that you have a column with distinct values to show you which rows are which between the two tables this can be done with a simple update statement. <pre>UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3</pre> If you are worried about creating one massive transaction you can [...]
View Answer
| April 19, 2013 12:58 AM
BULK UPDATE, SQL Server 2005
Assuming that you have a column with distinct values to show you which rows are which between the two tables this can be done with a simple update statement. <pre>UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3</pre> If you are worried about creating one massive transaction you can [...]
View Answer
| April 19, 2013 12:58 AM
BULK UPDATE, SQL Server 2005
How to prevent SQL update trigger from firing on insert?
You can merge both triggers into one trigger for update and insert: <pre> CREATE TRIGGER <trigger name> ON TableA for INSERT,UPDATE</pre> If you have different logic for update and for insert, you can check Inside the trigger which command fired it. There are two ways to do so: 1) If you have a column that [...]
View Answer
| April 23, 2008 2:33 PM
SQL Server, SQL Server 2005, T/SQL, Triggers
You can merge both triggers into one trigger for update and insert: <pre> CREATE TRIGGER <trigger name> ON TableA for INSERT,UPDATE</pre> If you have different logic for update and for insert, you can check Inside the trigger which command fired it. There are two ways to do so: 1) If you have a column that [...]
View Answer
| April 23, 2008 2:33 PM
SQL Server, SQL Server 2005, T/SQL, Triggers
full-text replication SQL Server 2000
You need to manually create the full text index on the subscriber. Full text indexes are not included in replication. Has the snapshot been deployed to the subscriber?
View Answer
| April 21, 2008 6:19 PM
Full-text databases, SQL Server 2000, SQL Server replication
You need to manually create the full text index on the subscriber. Full text indexes are not included in replication. Has the snapshot been deployed to the subscriber?
View Answer
| April 21, 2008 6:19 PM
Full-text databases, SQL Server 2000, SQL Server replication
Migrating from MS Access to SQL Server Express
Microsoft has an upgrade advisor available on thier website to assist in migrating from Access to SQL Server. You can find the upgrade advisor <a href=”http://www.microsoft.com/sql/solutions/migration/default.mspx”>here</a>.
View Answer
| April 18, 2008 6:27 PM
Microsoft Access, SQL Server Express Edition, SQL Server migration
Microsoft has an upgrade advisor available on thier website to assist in migrating from Access to SQL Server. You can find the upgrade advisor <a href=”http://www.microsoft.com/sql/solutions/migration/default.mspx”>here</a>.
View Answer
| April 18, 2008 6:27 PM
Microsoft Access, SQL Server Express Edition, SQL Server migration
Delete query
You’ll want a delete statement along these line. <pre>delete from Orders where CustomerId = 121 and OrderID <> (select max(OrderId) from Orders where CustomerID = 121)</pre>
View Answer
| April 18, 2008 6:10 PM
Access 2000, Database, DELETE statement
You’ll want a delete statement along these line. <pre>delete from Orders where CustomerId = 121 and OrderID <> (select max(OrderId) from Orders where CustomerID = 121)</pre>
View Answer
| April 18, 2008 6:10 PM
Access 2000, Database, DELETE statement
