How to Upload Image into SQL Server 2005
Please i need help to upload images into sql server 2005 using vb.net 2008. kindly assist please as i am working on an application that would require users to upload their credentials.
Answer Question
| April 11, 2012 6:40 AM
SQL Server 2005, VB.NET 2008
Please i need help to upload images into sql server 2005 using vb.net 2008. kindly assist please as i am working on an application that would require users to upload their credentials.
Answer Question
| April 11, 2012 6:40 AM
SQL Server 2005, VB.NET 2008
How do I subtract 3 days from current date only when current day = 2, so that I retrieve the previous Fridays date?
I am new to using T-SQL, so there is probably an easy way to accomplish this, but I can’t seem to get it right. I want to retrieve the previous day’s date (requires a weekday) to use as a comparsioin to a date field in the table, format is YYYYMMDD. When the current date is [...]
Answer Question
| April 10, 2012 7:59 PM
T-SQL, T-SQL 2008 R2
I am new to using T-SQL, so there is probably an easy way to accomplish this, but I can’t seem to get it right. I want to retrieve the previous day’s date (requires a weekday) to use as a comparsioin to a date field in the table, format is YYYYMMDD. When the current date is [...]
Answer Question
| April 10, 2012 7:59 PM
T-SQL, T-SQL 2008 R2
Creating clustered index on exiting table
I have a SQL Server 2005 Enterprise Edition database table that has 768,526 rows in it with no primary key or clustered index. This database’s logs are getting shipped to a disaster recovery server on an hourly basis. I need to create a clustered primary key constraint on this table; however when testing in my [...]
Answer Question
| April 17, 2012 1:55 PM
SQL Server 2005, SQL Server Indexes
I have a SQL Server 2005 Enterprise Edition database table that has 768,526 rows in it with no primary key or clustered index. This database’s logs are getting shipped to a disaster recovery server on an hourly basis. I need to create a clustered primary key constraint on this table; however when testing in my [...]
Answer Question
| April 17, 2012 1:55 PM
SQL Server 2005, SQL Server Indexes
update the tables in to two server using a single ssis package
i have 2 servers server A and Server B.i have written a package in server A.i want to update the tables in both server A and B.when i execute the package from BIDS it is working fine when i schedule the package in agent job i am getting the below error. Executed as user: RICRDWDEVSYSTEM. …ckage [...]
Answer Question
| April 5, 2012 10:04 AM
SQL Server 2005, SSIS Package 2005
i have 2 servers server A and Server B.i have written a package in server A.i want to update the tables in both server A and B.when i execute the package from BIDS it is working fine when i schedule the package in agent job i am getting the below error. Executed as user: RICRDWDEVSYSTEM. …ckage [...]
Answer Question
| April 5, 2012 10:04 AM
SQL Server 2005, SSIS Package 2005
unable to connect sql server 2000 on network
We have sql server 2000 instance on a machine say “comp1″.The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the “comp1″ via run and give password then i am able to connect through SSMS Can someone give [...]
Answer Question
| April 11, 2012 1:19 PM
SQL Server 2000, SSMS
We have sql server 2000 instance on a machine say “comp1″.The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the “comp1″ via run and give password then i am able to connect through SSMS Can someone give [...]
Answer Question
| April 11, 2012 1:19 PM
SQL Server 2000, SSMS
How to connect my computer to SQL server 2005
I need your kind support in connecting my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards..
Answer Question
| May 16, 2012 10:43 AM
SQL Server, SQL Server 2005
I need your kind support in connecting my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards..
Answer Question
| May 16, 2012 10:43 AM
SQL Server, SQL Server 2005
user_change.sql
in order to change the table names to the target system sid after performing a restore of database from another system will the following code work – – Before running this script, replace the following[Br type=”_moz” /> – @NAME@ – your new <SID> in lowercase (prd for example).[Br type=”_moz” /> – [...]
Answer Question
| March 28, 2012 12:16 AM
ECC 6, SQL Server
in order to change the table names to the target system sid after performing a restore of database from another system will the following code work – – Before running this script, replace the following[Br type=”_moz” /> – @NAME@ – your new <SID> in lowercase (prd for example).[Br type=”_moz” /> – [...]
Answer Question
| March 28, 2012 12:16 AM
ECC 6, SQL Server
Insert values into database from form VB.NET
Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want to [...]
Answer Question
| March 28, 2012 9:52 AM
SQL Database, VB.NET
Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want to [...]
Answer Question
| March 28, 2012 9:52 AM
SQL Database, VB.NET
Matching key question – resubmitted
Hi, resubmitting because the first upload did not seem to work… Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3…) Col2 has [...]
Answer Question
| March 16, 2012 10:25 PM
SQL Server tables, SQLServer
Hi, resubmitting because the first upload did not seem to work… Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3…) Col2 has [...]
Answer Question
| March 16, 2012 10:25 PM
SQL Server tables, SQLServer
SQL Server Database Maintenance Performance and Hyperthreading
I have two IBM machines with the same exact hardware 32 cores, 256GB RAM for each machine. One machine has Hyperthreading enabled and the other does not. When I run maintenance jobs (dbcc checkdb, and rebuild index) for the database that is 1TB the maintenance job takes 8 hours on the machine that has hyperthreading [...]
Answer Question
| March 13, 2012 10:45 PM
microsoft server 2008, SQL Server 2008 64-bit
I have two IBM machines with the same exact hardware 32 cores, 256GB RAM for each machine. One machine has Hyperthreading enabled and the other does not. When I run maintenance jobs (dbcc checkdb, and rebuild index) for the database that is 1TB the maintenance job takes 8 hours on the machine that has hyperthreading [...]
Answer Question
| March 13, 2012 10:45 PM
microsoft server 2008, SQL Server 2008 64-bit
Schedule SQL job to run and export to CSV file
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!
Answer Question
| May 8, 2013 11:45 PM
CSV, SQL Jobs, SSMS 2008
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!
Answer Question
| May 8, 2013 11:45 PM
CSV, SQL Jobs, SSMS 2008
RUNSQLSTM ALTER TABLE
i’m trying to run SQl statment in batch job to alter Table CCSID to 420 but i have error Reason code 10 Hani
Answer Question
| February 27, 2012 10:51 AM
AS/400 V5R3M0, SQL tables, SQL/400
i’m trying to run SQl statment in batch job to alter Table CCSID to 420 but i have error Reason code 10 Hani
Answer Question
| February 27, 2012 10:51 AM
AS/400 V5R3M0, SQL tables, SQL/400
Calling stored procedure in a database to query data in another database
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]
Answer Question
| February 27, 2012 10:25 AM
SQL Database, SQL Server 2005
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]
Answer Question
| February 27, 2012 10:25 AM
SQL Database, SQL Server 2005
Accessing Report Permission Using An Stored procedure in SSRS
I have created an Report and I want to give Access to only few to View Report. Is there a way to use a Procedure to grant access to Users.
Answer Question
| February 27, 2012 6:55 AM
SQL Server, SSRS
I have created an Report and I want to give Access to only few to View Report. Is there a way to use a Procedure to grant access to Users.
Answer Question
| February 27, 2012 6:55 AM
SQL Server, SSRS
Connecting visual basic with SQL server
i want to connect visual basic with mysql server
Answer Question
| February 27, 2012 10:14 AM
SQL Server, Visual Basic 2008
i want to connect visual basic with mysql server
Answer Question
| February 27, 2012 10:14 AM
SQL Server, Visual Basic 2008
Load balance of SQL database
When my database has grown beyond the performance capabilities of a single SQL Server, what are the ways get increase the system performance?
Answer Question
| May 2, 2012 10:18 AM
SQL Server 2005, SQL Server database
When my database has grown beyond the performance capabilities of a single SQL Server, what are the ways get increase the system performance?
Answer Question
| May 2, 2012 10:18 AM
SQL Server 2005, SQL Server database
Connecting SQL server 2005 with IAN connection
how we can connect sql server2005 with lan area? what are all the settings and options want to change?
Answer Question
| February 28, 2012 11:51 AM
SQL Server 2005, SQL Server career advice
how we can connect sql server2005 with lan area? what are all the settings and options want to change?
Answer Question
| February 28, 2012 11:51 AM
SQL Server 2005, SQL Server career advice
How do I resolve this SQL error
[-1] SQL Error: ‘[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ‘PK_cat_validation’. Cannot insert duplicate key in object ‘dbo.cat_validation’.’ SQLState=’23000′ SQLNativeError=2627.
Answer Question
| February 28, 2012 11:52 AM
SQL error messages, SQL Server 2005 error messages
[-1] SQL Error: ‘[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ‘PK_cat_validation’. Cannot insert duplicate key in object ‘dbo.cat_validation’.’ SQLState=’23000′ SQLNativeError=2627.
Answer Question
| February 28, 2012 11:52 AM
SQL error messages, SQL Server 2005 error messages
Store and retrieve data in UTF-8 on SQL Server 2005
(Apologies:I put this question under Windows Server 2003 tag by mistake, so I copied and pasted it here where it should be) I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table [...]
Answer Question
| April 8, 2012 11:11 AM
SQL Server 2005, UTF-8
(Apologies:I put this question under Windows Server 2003 tag by mistake, so I copied and pasted it here where it should be) I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table [...]
Answer Question
| April 8, 2012 11:11 AM
SQL Server 2005, UTF-8
Store and retrieve data from SQL Server 2005 in UTF-8
I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table SQL makes it into question marks ???. What should I do to be able to store and read UTF-8 data? My columns [...]
Answer Question
| February 28, 2012 10:42 AM
SQL Server 2005
I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table SQL makes it into question marks ???. What should I do to be able to store and read UTF-8 data? My columns [...]
Answer Question
| February 28, 2012 10:42 AM
SQL Server 2005
