Hi,
With Management Studio, I created an SQL login (mylogin) then I created a schema (myschema) and finally a user (myuser) with "mylogin" as login name and "myschema" as default schema.
...
Hello,
Can anyone explain the difference between a SQL Server 2005 conversion from varchar and nvarchar to datetime or smalldatetime? Look at the following example:
SELECT DISTINCT HEDT...
I am getting following error while I am trying to insert the data to the remote database from the local database.
Error:
OLE DB provider "SQLNCLI" for linked server "69.57.179.9" returned me...
I am building a report that has a field for sales figures. How do I make the total sales column display as a currency format (USD) - ($0.00)?
TIA!
Hi,
How can i insert single quotes in databse,if i am trying to insert i am getting error like Incorrect syntax near 's'. Unclosed quotation mark after the character string .
Users are...
can anyone give interview questions for ssis ?
I have an Execute SQL task first and the query is Begin Transaction. I then have a dataflow that uses a Flat File Source, goes through a Derived Column transform, and loads into a table. After...
Running into "insufficient memory to run query" errors when performing scheduled maintenance tasks. I suspect this is due to improper configuration of memory or page file.
SERVER: 2003 64bit...
Is it possible to extract plain ASCII text from a SQL Server IMAGE field?
When trying to use database mail, I get an error whenever I send test mail outside the domain of the originating address. The error is: The mail could not be sent to the recipients because of ...
Pretty straightforward, I am looking for the code to import a MS Access MDB database into SQL Server 2005 with a stored procedure.
I have seen examples of this with excel or csv files, but ...
Please help with this error message while trying to parse tsql stmt
Declare @SQL varchar(1000)
Declare @sWhere varchar(20)
Declare @myTable TABLE ( myField1 varchar(10), myfield2 varchar(10...
Hi,
I have just inherited this enviroment 2 weeks ago. and am trying to implement best practices for security. I am in the process of removing users from the sysadmin role. We are running...
I am trying to pass a variable to a sql statement....select * from table where idnumber in (?). My variable is a string from a table. It is in the format... 3373, 3232, 3433 However...
Dear Sir / Madam,
I would like to create a Materialized Views in SQL Server, please let me know:
" Will this view contain data as a table (kind of), periodically refresh?
" i.e. like O...
I have a 2 DataGridView controls bound to 2 datasets. When the user selects a record in DataGridView 1 and wants to add it to DataGridView 2, I want to check to see if it already exists and i...
I would like to know what does the value -1 indicate when I execute the command.ExecuteNonQuery which excutes a stored procedure.
iResult = command.ExecuteNonQuery
iResult shows -1
Is it possible and how to change a named instance of SQL 2005 Standard to the default instance?
Here is the scenerio: Currently, the server has SQL 2000 Standard installed. The client would...
Receiving this in the SQL log files for over two weeks now..unsure where the problem lies.
Date 10/31/2007 3:20:45 PM
Log SQL Server (Current - 10/31/2007 3:23:00 PM)
Source Logon
...
I've just installed SQL Server 2005 and I'm trying to get connected to it so I can play with creating/editing databases. I open up the SQL Server Management Studio but take a look at what I g...
I am currently importing data back into a database after it was accidently deleted. However the source that I am importing from also contains data that still exists in the destination database...
This is a syntax question about Transact-sql (SQL Compact Edition) used from within VB.Net 2005.
I need a select statement to retrieve several columns from the record where one of the colum...
We have been using a vendor in an ASP environment for some time now. We have decided to move to an inhouse server and the vendor has sent us our data in a .bak format. They said it was a bac...
I have a SQL SELECT statement that has a clause:
"WHERE filename LIKE " & sFileSpec
and when sFileSpec is "4_03" it returns a match for filename = "4303". Does the underscore character act...
I have a database approximately 40GB in size. The database's indexes are heavily fragmented. I would like to rebuild the indexes using the following script
ALTER INDEX ALL ON [LIVEDATABASE]...
