Hi,
I'd like to to increase the size of the 2 columns EQ_ID and EQ_STD on my DB SQL Server 2005.
EQ_ID char(50)
EQ_STD char (50)
How can I create a script to change the size of this column...
Does anyone have a query to count the number of tables in a database? Doing some analysis here...
TIA
Hello. We are attempting to implement an automated process using BCP to run a query and dump the results to a text file. We are not knowledgable about the utility but still have to get it wor...
I have a SQL table, and I am using T-SQL. I have one table with some null values in one of the columns. I want to replace the null values with zeros. I am using this query:
Use Energy_Db
U...
How can i use sp_change_users_login 'auto_fix' to update all my logins on a server so i don;t have to use
exec sp_change_users_login 'update_one',
'nsmith', 'nsmith'
over and over again.
Hello,
when i run this stored procedure i get an error message saying :
"Server: Msg 203, Level 16, State 2, Procedure spUPLOADOUTOFSTOCKS, Line 27
The name 'INSERT INTO DBO.OOS_UPLOAD (SIT...
How can I declare a global variable in SQL Server?
I want this varaiable to be visible across multiple stored procedures.
Hi,
I need to give developers permissions to several SQL Server 2005 databases so they can ONLY view all the tables, views, stored procedures etc, but not create/edit/delete/modify any. If ...
Hi all,
Let's say you have 2 tables (UserSecFunctions and UserInfo). The UserInfo table holds all UserIDs you need to insert into the UserSecFunctions along with some other minute data. How...
HI,
Could anybody please let me know how to do a drop or truncate on a table variable?
I can do delete, but table doesn't reseed the identity value.
I currently have a Select statement that is in the format of:
SELECT x,y,z From(Select acctn as 'x',acctk as'y',acctl as 'z' FROM Table where....) ORDER by x.
My question is as to whether ...
Hey guys,
I have a view, and I want to create a table based on that view, much like the MySQL way:
CREATE TABLE MyTable (MyKey INT NOT NULL AUTO_INCREMENT) SELECT * FROM MyView
Actually...
I have SQL 2000. Currently the data file and the transaction log file for a database are located on the same drive. I just added a new drive to the system and I would like JUST the transacti...
I am getting an error when i try to parse the query:
Server: Msg 2714, Level 16, State 1, Procedure ap_rpt_chunit, Line 32
There is already an object named '#baseline1' in the database.
S...
1. What are the precutions that I need to take in shrinking .mdf and .ldf files
2. What is the command to shrink or the steps in EM to shrink say test.mdf
3. What is the command to s...
I have table [Product].Items and table [Technology].Items
Note that Product and Technology are schema names, so more accurately, I have table Items in schema Products and table Items in schem...
I get the following error when I execute the following statement
SELECT *
FROM OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\temp;','select * from ...
Hello
I keep recieving the following message in Event Viewer:
"The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs." Event ID 17896
It is an informatio...
We are using BCP to query out from a table into a .csv file to another server. Is there a way to get it to pick up the column names with the query, or some type of -switch we should be using.
Where can I find a (64-bit supporting) odbc driver for windows to connect to the iseries as/400. I can't find it anywhere on IBM's site?
Thanks!
What is the difference between the nvarchar and varchar datatypes? Which should be used? Also, what is the proper way to pronounce them?! :P
Thanks,
br
I am using VS.NET 2005 and SQL Server 2005
I am getting an error running the following query.
SELECT [notes] FROM [Info] WHERE (CONTAINS([notes], @notes)) ORDER BY [info_date] DESC
The...
Hi,
I am having an issue with my SQL Server since we upgraded it to 2008 (from 2005).
Although the text search works fine the Microsoft Full-Text Engine Filter Daemon process (fdhost.exe) ...
Capturing network frames behind a SQL server 2005 NIC i get 70% of them being:
TDS Response Packet[Malformed Packet]
It seems to affect Network requesting from that SQL server.
A...
is there a way to convert it from varchar to float?
CONVERT(float,@Number)
thx
