New Data Field in Stored Procedure
When I add a new data field in a Stored Procedure, how do I make the new field available to the Crystal Report?

Answer Question   |  May 3, 2012  3:09 PM
Stored Procedure variables

table size strange in SQL SERVER
Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl](     [IdUrl] [Int] IDENTITY(1,1) NOT NULL,     [IdSupply] [Int] NOT NULL,     [Url] [varchar](512) NOT NULL,     [UrlCod] [varchar](256) NOT NULL,     [Status] [Int] NOT NULL,     [InsertionDate] [datetime] NOT NULL, [...]

Answer Question   |  May 5, 2012  2:21 PM
Database, Microsoft SQL Server 2008, SQL Server

Installing a named instance using another edition’s installer.
I have a SQL Server 2005 standard edition installed with a default instance. I need to install an additional named instance. However I could not find the standard edition installer CD; and my colleague managed to dig out a copy of the Express edition installer. Can i use the Express edition installer to install a [...]

Answer Question   |  May 3, 2012  6:07 AM
SQL Server 2005, SQL Server editions, SQL Server installation

How can we get shell when dbms is SQL2008 and we found an sql vuln in REFERER field, which revealed version,dbs,tables etc?Sqlmap didn’t work.
Hello, During my last pen test I found an sql vulnerability in the REFERER field of the headers. This revealed me, using sqlmap with –referer option, the DBMS which is Microsot SQL 2008,all  db names, tables, db users etc. My problem is that I cannot test if a shell can be spawned, since xp_cmdshell cannot [...]

Answer Question   |  April 26, 2012  9:54 AM
MSSQL 2008, SQL injection

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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