Hello,
I have a C# App that accesses a SQL Server 2005 Database using SQLClient.I frequently back up, Detach and attach the database from Management Studio Express.
I am trying to figur...
I am trying to upgrade SQL 2005 Express to SQL 2005 standard.
During the system configuration check all the checks return a green check mark except the last one.
It has this warning mess...
What is the main difference between a clustered and non-clustered index
Drop everything in database B, copy everything in database A into database B.
Note: Avoiding restoring database A as database B
I would like to issue this command:
BULK INSERT TableA
FROM 'C:\Temp\TableA.txt'
WITH (FORMATFILE='C:\Temp\TableA.xml');
But I haven't moved to SQL Server 2005 yet.
SQL Server 2000 doe...
Hi,
I have a DateTime variable:
DECLARE @Date datetime
SET @Date = '2007-07-20'
After I'm done with this, How can I modify the @Date variable to something like this:
DECLARE @Modi...
I am running MSSQL Server 2005 Standard Edition on Windows Server 2003 Enterprise Edition.
I am using the SQL Server Management Studio included witth the MSSQL 2005 Standard installation runn...
I am trying to start Distributed Transaction Coordinator in one of the node of my clustered server.
It is running in Windows Server 2003 Enterprise Edition. But I received the error mesage as...
Hello all. I am not sure if someone disabled something but SQL Server agent wont start and says it was started and stopped. I looked in the event log and I am seeing the following:
SQLSer...
Hi Experts,
Can someone please post a function for MSSQL Server that splits the following string into integers:
300,400,900,1200
Thanks
My goal is to look up all previous test a student has taken and see if they are complying with testing policy. I take the current test and find the date range that it falls in (that is which ...
I am trying to import data using SSIS from an AS/400 iSeries Database into a SQL Server 2005 Database.
I am trying to use SSIS to import the data. My issue that I am having is that when I tr...
I have 2 ms sql 2005 servers when I export from server1 to server2 tables in server2 appear as owned by server1 example:
instead of table dbo.names (as was in server1) I get server1.names ...
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...
Hi there,
Can anyone confirm something, moving from oracle to sql server, and having a problem with a query, i have made a column case sensitive so the following query returns no records as...
I'm running SQL 2005 Management Studio on an XP Pro workstation and am running the following SQL Statement to prevent the insert of duplicate data from a Table called Software to a table calle...
I notice my SQL Server 2005 uses
SQL_Latin1_General_CP1_CI_AS
collation which ignore case when comparing string.
How can I overcome this limitation?
Hi, I am successfully able to set report parameters and use them in the data parameters on a main report I want to pass all the values now to the drilldown report. I went to the properties of ...
where do I go in sql server to determine whether it is in case sensitive mode? And also change the mode.
Many thanks.
Hi,
I need to create a SSRS report that shows data from 2 different Stored Procedures that expect the same two parameters. How do I do this please? One Stored Procedure will return 3 or 4 l...
I am running SQL Server 2005 Enterprise Edition, on a Dell PowerEdge 2950 64 bit server.When I try to connect to the data in the database i recieve this error message:
An error has occurre...
Angellll helped me create this Oracle function below which allows me to insert a new record into an Oracle 10g table.
I'm able to run this insert statement successfully from SQL Server Man...
While buying one of the product, seller is informing that it is 2000 compliant. According to seller, there are few stored procedure in the database which are not compliat with SQL Server 2005 ...
I am attempting to kill a rouge Trace in SQL 2005 without success!
I have attempted:
exec sp_trace_setstatus 1,0
With the result of:
You do not have permission to run 'SP_TRACE_SETSTAT...
hi,
i need to convert a datetime value to 'dd/mm/yyyy hh:MM' format in T-SQL. can i use CONVERT function to do it?
thanks
