Excel file to SQL DB Table
The excel file must be parsed for CheckSums and then transfer columns to a table representation in SQL
The destination has different column names than present wi...
When I attempt to optimize a database, I keep receiving the below error message in my error logs despite that I've shrink the data and log files:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] ...
Can somone tell me how to set the option to allow a stored procedure in a database to run
EXEC master..xp_cmdshell
Thanks,
Steve
Microsoft SQL Server 2005. I cannot login to the server. I am getting 2 errors. Login Failed for user Error: 18456, and Shared Memory Provider, error: 0 - No process is on the other end of the...
I know this is an easy one and I have seen the solution before but I'm tired and can't figure it out.
I am getting an error
Conversion failed when converting the varchar value '../image/...
Using Enterprise Library, C# .NET 2, SQL 2005
I have some code that I need to run in SQL 2005 that really makes sense to be a function rather than a stored procedure (2 such instances actua...
How do I "read" a text field and add formatted text to it in SQL 2005? If not formatted, how to I add to it at all?
Best Case:
cola = 'some text'
after concatenation
cola = 'some text
...
Hi,
I have got these two concepts from online in SQL Server 2000 / 2005 - Difference between "Temporary Table" and "Table Variable". Can you please correct me if i am wrong / and please exp...
given a cell in column TOPIC, how do I write a select where the X position of a character in a cell results in a 1? The cell is in nvarchar and always contains a string of 1's and zeroes
F...
Hi All,
I am having some trouble getting a Grand Total column at the end of my matrix report, such as you get by default in an Excel pivot table.
I have managed so far to add another col...
Hello all,
The HDD that holds the logs for one of our DB servers has run out of space (More has been ordered). Part of the reason for this is the log files have gotten rather large, as such...
I need to be able to call a SSIS package with a specific parameter for one of the variables. Basically the package needs to be triggered from an application (.NET, C#) with a specific value.
...
Platform = MS SQL 2005, MSSMLBIZ, OWC11.dll, Vista Ultimate, VS 2005, Office Ultimate 2007
I cannot un-install Microsoft SQL 2005 completely, so I cannot re-install it and finish building m...
Dear Experts,
I have a select statement which will return one or more rows.
But I need to forcefully limit it to only JUST RETURN ONE ROW.
Can someone please show me how to accomplish t...
I have created several SQL accounts on a SQL 2005 server, enforcing password policy, but not enforcing password expiration or "user must change password at next login."
I did not encounter an...
In the MySQL world there is a very handy command line program called mysqldump that (in addition to making CREATE TABLE statements) as creates INSERT INTO TABLE statements for the data itself....
Most databases allow an existing column name to be renamed with syntax similar to this:
Alter Table
Rename colnow to colnew;
Cannot seem to find syntax for MSSQL to do this. Can/How can...
Error when trying to rebuild master database on SQl 2005 on active passive node.The install screen pop and then error user installation cacellation error.
Before getting that error , I have...
I'm looking to import two select statements union'ed together that is using a distinct to get unique records:
select * into cpv2649 from
select distinct keyword from
(select keyword from ...
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...
hi
in ms sql server 2005
i want to create and ms sql user only has execute permission to stored procedures ?
any idea how to set this thing ?
I am attempting to take a database offline so I can then do a restore over the top of the database.
When I select "Take Offline" the app. freezes and produces event IDs 18456 & 1001.
The...
I would like ot know how to setup the SQL 2005 - Maintenance Plan to Truncate Transaction Log file to 5 GB. Our DB is not a Transactional DB so I have set the DB to only grow to 5 GB. My quest...
I would like to merge a field in multiple rows, into 1 field.
Example:
from:
1 | Test | Information |
2 | Sample | Information |
3 | Demo | Information |
into:
0 | Test, Sample, Dem...
if i have a dynamic sql query something like this
set @strsql = 'select @somevar = somecolumn from ' + @tablename + 'where condition '
exec @strsql
it does not populate the @somevar vari...
