Bytes - Microsoft SQL Server answers - Page 3

MSSQL bcp command help
Certification in Mind???
Only 90MB for SQL Server 2005 on a Windows 2003 64bit 12GB System
Using charindex AND substr to pull out data
restore .dat
Finding duplicate records
Looping through recordset creating calculated Rank Column
compare lock setting in sql srv 2000 and 2005
Automation error
SQL 2000 DTS tool - 256 char limit?
Create Index on View
Uncommon records from two table
Linking Windows SQL Login to user database
Determine the byte size of a particular row?
Calling Commonly Used SQL (reusable code)
BCP with special chars
joining multiple tables based on 1 criteria
Export to Excel, exclude header
Stored procedure incorrect?
Can a dropped table be recovered?
How to show field that not being group
need a query (columns to rows and rows to columns)
Softclarity Builder
Round to 2 decimal
Creating Database
Replication of MSSQl database from one server to another
compare ntext to datetime
Computerised Date
How do i use LIKE for a search query?
automatic id generation
Accepting wildcards like % in input parameters of stored procedures
Distinct Row based on description count
Slow Query causing application problems
Re: problem with column alias
Query problem
create database
Trigger and procedure
query
Insert in two tables
Please can someone help
Re: problem with column alias
just u click make a money online
How to insert dates using datetime functions.
Having problems using BCP for CSV output
import data from excel into sql server 2000 by C# in .net
Re: ALTER proc vs IF EXISTS DROP/CREATE
count the rows
ALTER proc vs IF EXISTS DROP/CREATE
Cursor does duplicate records
ODBC--call failed.
BCP error on a database with name in two words
Query Across Multiple Tables
Delete Trigger
Intrusion Detection Strategies
Delete a BackupDevice in Code
SQL Server Scripting Question
Date conversion problem
SQL DB Backup
Select Query with = not returning any rows
Stored Procedure to reliably update two tables.
Dynamic field names
SQLServer2005 procedures
sql update trigger that updates table 2 when table 1 is changed
Restoring a SQL Server 2005 database without the log - revisited
SQL Server Agent confuse?
Capturing the date and time based on clients timezone in SQL Server 2005
Import data from comma delimited text file into an SQL Server table
Help to query a date range
Why is SQL Server procedure not executing properly?
Handling multiple database with stored procedure
Connection is busy with results to another hstmt
sql server query problem
DB BAckup
Distributed query [drawn out problem]?
Insert Into Select trouble
Login failed user error in running web application
SNL Sql
Error updating the employee details!", help
ms sql 2000 - create update script
Problem in using LINQ to SQL
any sql code to search database tables ?
Getting check constraint error from sproc?
Recursive Stored Procedure
how to write trigger in sql server 2005
how to sum some field in a row
Strange issue in execution of sql
how to Backup only selected tables
How 2 store values through Stored Procedure from ARRAYLISTwhich is from Database only
SQL Query for Dummies
CONVERT() problem
UPS WorldShip SQL
problem with MS sql server 2000 database table
various errors connecting - possible permissions problem
Group By and Having are driving me crazy!
Problem with REPLACE with binary strings
how to decrease the size of database
Recursive update query
Difference between check constraint and dafault constraint
Latest updates in database management and SQL server tools andtechniques
Da MySQL a SQL express
T-Sql & Active Directory Roles, Identification of original login ofimpersonated ID's and Suspended processing
unable to install SQL Server 2005
merge data from two sets into one
select @@identity
no text in object
SQL Server / Access commands/recordsets
How to create a new database with an unknown name?
Re: Best practice on nullability and default value
Passing querystring to a website through sql report
How to Lock and Release Table?
Formatting datetime when including in a PRINT command etc...
Pb to open an attached mdf file
RESTORE DATABASE is terminating abnormally
Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
Orders Database Storing Orders
Patch for KB948110 causing random "Could not find database table ID"errors
Update record of two table
Unable to view SQL7.0 Table Records through visual basic
Right Justified with leading zeroes
getting error in query..
Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
Update Record in two Table using trigger
How to compile TPC-H ver2.7 on Windows XP?
complicated query (where statement inside select statement, don'tknow how to explain it)
Building a datacube with Excel 2007 and SQL Server 2000
Insurance data models...any tips on good starting point?
DB Backup
Are Deadlocks inevitable ?
Help With Full Text Search. Performing AND across columns
rupdating duplicate entries with random numbers
Changing the name in the ServerName column
Execute store procedure
How To Save File to varbinary(max) in SQL 2005
Schedule a Query
SQL Query Analyzer
trigger - Incorrect syntax near 'INSTEAD' error
Multiple attribute design that need to be searchable
Multiple attribute design that need to be searchable
Strange join in query
Displaying records in new line
Sql Server 2005 Replication
does this backup sequence commit all data to the database
Sql Inner Join/Union
SQL problem - a variation on outer join
if condition in stored procedure
BACKUP LOG questions
Common data
Could not execute a package by a scheduled job
dbcc shrinkdatabase
Testing
DB Structure Advice - lots of measurements in DB or file refs?
programmatically stopping and starting transactional replication
login failed
Data loss importing from Excel
Index on field length
transaction log
How do I number an output field consecutively?
Selecting criteria from SQL DB
How to convert a number to Hour:Minutes?
Database management and latest updates on SQL server
Downloading database from server on client machine
Re: [ANNOUNCE] Release 1.3 of Mogwai ERDesignerNG available
Escape [] characters in an sql query
Edit/Rename attributes with many tables from excel file source
SubQuery Question
Match two tables.
Cursor among several databases
Alter Or Create Procedure?
design issues with large amounts of data
SELECTing from a DML statement
Mulpliplcation of all values in a column plus converting negative values
Reporting Services close download interface without exporting
Stored Procedure
Using UPDATE to sequentially abbreviate address information
Faster way to check if a record needs updating
SQL caclcualted field
Odd character appended to data
Datetime import/export issue
Dynamic ORDER BY
Yellowfin Business Intelligence Release 4.0 Announced to Industry
SQL Permissions
Sql query date problem
mSQL + Perl = Phantom rows
SQL Query Assistance
slow queries for a particular database
sql agent JOB to Backup Database and Maintain Backup Files
Need a script to recreate scheduled jobs
Help needed for Data formatting.
How can I do that using a trigger
Foreign key
OLEDB configuration when deploying multiple SSIS packages
Variable database name in stored procedures
Crystal reports
Decimal point and comma
Re: Stop hotlinking to a specific file & keeping a counter
Please Help - Can't check for duplicates
Deploying an app with SQL Server (installation on client machine)
How to secure a database ...?
Can I search for a string in a set of stored procedures?
GROUP BY a computed column
Creating a database from set of TSQLl files
Concatenate in MSSQL
Storing BLOBs outside database
Re: Duplicate Tests - Help Please
Re: Grouping by Day for a Date Range
Question about recompiling a dll
table naming convention about this case..
Latest updates on SQL server 2008 tools and techniques
Computing a column that is a percentage of the sum of another column
Database security (non-existent?)
Tool to chase down the consequences of adding field to DB tables?
Applying tranaction log to old data file
Re: Database naming conventions?
Latin1_General_BIN comparing two char strings
alter table query not working after working at least once. MS SQL2000
Re: Database naming conventions?
Re: Database naming conventions?
Transact-SQL for Restore Filelistonly using a variable
Toad for MSSQL problem: closing script file doesn't "release" thefile?
bcp out in UTF-8 format
Kuljetusalan ongelmista
Basic SQL Statement Question
Differences between relational DB and warehouse ?
tbl_A CROSS JOIN top 1000 rows of tbl_B?
bcp out empty string into csv files
C++ API for SQL Server?
SQL 2008 EULA and pricing
SqlBulkCopy.WriteToServer() blowing up on tables with Identitycolumns
Performing multiple bulkcopies for different tabels
stored proc with datetime
Forget about Referential checks??
Re: Not finding GUID value after migration sql 2005 to 2000
bulk insert in clustered index table
Re: Vaalirahoitus (oli: Re: Irlanti pelastaa Suomen)
database design
Re: Not finding GUID value after migration sql 2005 to 2000
DB migration
Newbie basic questions
HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers ,
Anyway to declare and use variables in a View
MSDE upgraded to SP4 but showing SP2
Select from a access table
Migration of an Access Database. How is the best way?
Problem connecting to SQL Server from Access Database
simple SQL engine
Fuzzy logic for duplicate identification?
Full text search in albanian
database owner?
Convert Int to Date
IF within SELECT
live online training
Re: "Maksanhierontalaite" ; )
Problem With View and Changing Field Length
stored procs
Looping Through the Records returned from a DTS Lookup
Snap-in failed to initalize.
Compound vs Simple Indexes
Re: Ruuska
Not an ad hoc query?
Stored Procedures and Commiting Data
Connect problem
Dell c610
Re: search pyrkii nettiin
Using Case within Select
SQL 2005 report deploy issue
Is this a correct table structure for my database?
How to find if instance is cluster or non-cluster
SQL Server 2008 - Filestream
Error running DTS script in VB
SQL->RDF? Best question about semantics technology wins admission to LinkedData Planet
How do do a query against hardcoded row values
Need SQL Server Dasbase Admin
simple ALTER Table query question...SQL 2000.
Disabling Triggers
Installing sql server 2000 on windows server 2008
Update Query Runs Forever
Re: Outer joins in MS SQL 2005: why is it this way? better yet, any resources on these nuances?
How to sell sql skills? (Need your knowledge and thoughts)
(Newbie) Join problem.
Problem with joins in SQL.
where do I download sql odbc drivers from?
Re: Connection pooling issue with pass through queries
Join zero padded char to varchar
Re: Connection pooling issue with pass through queries
Re: Strange select
Re: Strange select
Re: Need Help With an Update Script
strange Problem
your thoughts on this please
SQL Server 2000 UDF Intermittent Slow Execution
Sysmergesubscriptions question
examples with SS2008 -xEvents?
Need Help With an Update Script
delete a named instance - how?
SQL Server Browser service?
select from two tables
Strange connection problem
Help with an Update Statment
Install new instance...
Simple Query Question
Where's my instance???
DBMS advantage and disadvantage
Rename Default Instance Name SQL Server 2005
Cannot Read Varchar(max)
relocating Outlook Business Contact manager
confusion over indexs via primary key and clustered index
Link to external file
SQL Excel - freeware add-in for excel
Modeling/Constraint question
Email Generation from within SQL/Server 2005
Re: SELECT Optimalization
Best pratices to manage the "same logical" database on multipledatabase engine types (postgreSQL, SLQServer, etc..)
Help with SQL Backup Problem
DTS Transfer Data Task - output to text file with field names infirst line
I want to update the column in a table based on the updation of theother column in the same table
syscharsets unicode
nested stored procedures and returning lots of rows
Checking for duplicates in a database table
firewall rules for SQL Server
Modifying registry information to change type of login logging
Suggested DB Reverse Engineering tool...
Local Security Policy - Restricting Access
Cursor and Procedure
select from row1 to row n
Reattaching database - identity_insert set to off
Most Helpful Professional Award
Cross Database Select
Merge process could not update the list of subscriptions
a and (b or c) better than (a and b) or (a and c) ?
caching table Problem
How to return a Pk value from one stored procedure to another storedprocedure
create dynamic variable in procedure
Advanced SQL Cubing
SQL 2005 on Windows Server 2008 - Slow Connection Time
Re: Display duplicate rows
Help!
Re: comp.databases.ms-sqlserver
Altova v2008r2
Urgent: Deciphering binary code executed against the database
copying row from same table and adding value from form.request
Doing a SELECT INTO using a Stored Proc as the data source
SQL Statement Problem : Separate long varchar into word seqments 35chars long
Setting SQL Server Agent Account without being part of a domain
Limiting table access using stored procedure.
SQL Select All Items where one meets the criteria
optimal selection of all records for a certain month (illegal datesOK?)
updating multiple columns with subselect
Selecting several types
Prevent Excel and Access access to SQL 2000
Read HTML File though Network for Email.
Disable and Rebuild or Drop and recreate Index
Force protocol encryption on hosted database
How to implement Audit/Alert for Row level access?
Orphaned tupels, should I clean or is it ok to leave?
Full text indexing scheduler SQL Options
SQL and Database Design newsgroup
ASP.NET 2.0 not connecting to SQL Server (not web.config)
Help with bbrowser cell focus ?
Client applications
Re: SELECT * vs SELECT col1, col2
COLUMNS_UPDATED() with triggers
Re: How to show Median in a GROUP BY clause? (AVE works, Mediandoesn'
beginners question...
Conditional data copy SQL Server to Oracle
Can you tell who last edited a SProc, and when?
Select CASE returning NULL value
Why freetext query become very slow all of a sudden
Select date in british format
back up jobs, re-index question
MSSQL - MySQL
file crawler
How to recover deleted records?
capture and save running sql query to database table (for logging)
Use of having with additional select
design question - type heirarchy with supertype queries
Performance question concerning varchar(max)
Yet another basic SQL question
using LEN to find a first word greater than 17
Job ends successfully even when it's not true
exporting a table with long field names to Access
Basic SQL Question
FAQ & Solution: How to generate a number automatically for thePrimary Key when inserting a record?
Another new DBMS
copying data from one server to another
How to find records with length greater than 17
CHECKSUM to determine record changes
first minimum date in the column for each distinct column a value
Re: Get rows whose sum matches a value
The Sql ranking OVERture
sp_prepexec syscomments?
select parent records that do not have a particular child
how to create my own primary key which auto-increment
Re: Get rows whose sum matches a value
Re: tempdb size question
Re: HELP WITH SELECT STATEMENT PLEASE
SQL Server 2005: functions become slow after a while
How to get the sql statement of a view? (by running a query or from ado.net)
Granting permissions for a user from another database
Login Seems OK but doesn't behave correctly
table trigger just hangs
SQL Server Management Studio
Dump table as INSERTs
Query Japanese Text in an NVarChar?
SQL 2005 XML Searching
import ADO DLL
Performing Bulk Load of XML Data
case-when error
Secure Auditor, 30 security tools at the price of one.
Secure Auditor, 30 security tools at the price of one.
Finding "missing" rows
Login failed for user 'sa'. Reason: Server is in single user mode.
Re: T-SQL Duplicate Record Help
Connection String on shared server- Almost there but need a littlehelp
Please recommend SQL book with excercises
Re: default value wich is not in DDL.
Handle Triggers in MS Access 2003 with SQL Server as Back-End
Calculating Opentime between several records.Using SQL Server 2000.
Calculating Opentime between several records
How to compare date,month,year
Counting days in date fields
SQL Query Email
How to get Last Thursday Date
Xml Bulk Load in SQL 2000 relationship error
Suffix in dates
Order of Triggers in SQL Server
How to list all servers of MS SQL server?
How are parameters passed in Triggers?
Number of Queries in Stored procedures...in SQL Server
SQL Query to select top 10 records except for the top 10 records
Getting specific dates in SQL
Help in writing SQL query
SQL 2005 to XML
Securing Tables/Views
Using two different database data in one application
xp_cmdshell syntax commands
Selecting Query
Violation of PRIMARY KEY constraint..how to solve this error?
Merge multiple row values to a single row
Primary Key
List all Databases
cannot change the type
Log file needs shrinking
Space Available 0.00
SQL Server Migrating from XP to Vista - How to copy databases over
Accessing VIEW via SELECT statement from another server
using exec
bulk copy
Replication - SQL Server 2000
Update SQL table with Dataset
Join table from sqlserver and sybase
sql job schedule
Insert a record that has been deleted
Join Query
microsoft sql server management studio
Format Number in Sql Query
How use the substring method with sql 2000?
Problem with Query
How to get the month back from sql server 2000?
Select a Random Sample of Raws
Is it possible to run SQL-Cursor through cmd??
hi needed help in a query
How to stop writing into log file when DTS is executing.
Convert Character Sets On Export
Issue with inserting record in db table.
How to reset Identity column
Identity Column
Issue Select statement to read Oracle table from SQL Server
Using LIKE Operator
How to set certain value into field?
Select query help
data type for a field in sql server
How to calculate duration in a query
Required Data between two dates
Sql server 2000 Hanging problem
How to display pop-up message in bold
front end details
Plannig indexing
how to configure sql server 2005...
How to fetch data using OPENDATASOURCE and Linked Server
Date Between Problem
DISTINCT UNION ALL query help (employees and dependents)
Sql Stored Procedure
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Check null values for more than one column
Index On A Columns
Cannot schedule a maintenance plan
SQL Server Isolation Level - Table Locks
Find hard coded strings in SQL: can it be done programatically?
how to get the row count value
Is it possible to insert records through view....
If conditions for stored procedure
Insert more than 40,000 records
MS Project 2007 SQL Server Enterprise
Updating multiple columns with several conditions
Round Function
Specific Reasons To Denormalize
Differnece between SelectStatement in View and StoredProcedure
where do I download sql odbc drivers from?
(Newbie) Join problem.
Problem with joins in SQL.
Join zero padded char to varchar
Exporting data from SSPS 15.0 to SQL Server 2000
Alter Column datatype
store procedure
Access Runs SQL Server Slower
Progress Bar
Date calculation in SQL 2005
Stuck with Truncate
Stored Procedure for Searching
auto generate ID'S in sqlserver
Migrating Access to SQL "IIF Statement" Issue
db open
changing the position of column by writing a query
How to activate distributer agent in subscriber or publisher?(REPLICATION)
date problem
Problem with Query
Flag in SQL
To change Date Format in Sql
Any SQL statements to return no records found?
plssssssssss help
shorting problem in query
Get number of days in a month
Creation of DALC using stored procedures
Regarding DALC Creation using stored procedures
which datatype takes actuall value
Converting Oracle SQL syntax to MS SQL 2005 syntax looking for a tool
IF Statements in Stored Procedures
Crystal Reports
insert actuall value in sqlserver
add float value
copying from one table to another
dataset transfer from client to server
SQL Trace
Using Round in a sql query
Concatenating Certain Rows in Table
sp
Rows
Parameter
converting char to int question
Showing a negative # as a positive?
Update query not working in SQL Server
SELECT data from two tables using same field labeled differently
Table
Permissions
Differences
Date
select maximum in a table
How to return a Pk value from one stored procedure to another stored procedure
execute SSIS package from windows app