View Full Version : Microsoft SQL Server
- sql profiler trace logs question
- BCP Export - Exlude Tailing Blank Space Terminator
- Database search optimization problem
- backup of database in public network system
- Best Virtualization Solution
- How to know when SQL Agent job completes
- How to Combine redundant values into one field using stored procedure !
- How to import Btrieve 6.15 Data to MS SQL
- connection keeps dropping never happened before
- My report doesn't show data!
- Need help with simple Query, multi column index...
- Insert row into a flat file.
- Internal Virtualization
- ERROR_MESSAGE() doesnot return column name to UI
- poor man's table partitioning implementation
- Help
- Query Using Pivot Table
- Error while installing English sql server on Turkish OS
- SQL Query Doubt
- Query Issues
- Order BY Clause Issue
- Decryption not working :(
- Output reversed when calling a stored procedure remotely.
- Log Usage of stored proc
- SqlServerException instead of batchUpdateException
- encrypting a particular column i.e password
- Ways/Tools to stress test a new system
- SSIS Data Flow fail
- Migrating SQL Express 2005 to PostgreSQL 8.4.4
- Database - RoyalCaribbean
- tempdb log troubleshooting
- trigger not returnign desired result
- SQL Server 2000 Manual
- Aging date
- SUM of each row added to the next?
- Sql script
- inserting unique or distinct values in table
- CrossTab? Pivot? Stuck!
- Removing Data From Tables Automatically
- XML extraction
- archiving strategy
- condense and concatenate
- updation in one table should reflect to another table.
- 'group by' issues!
- Mastering in Joins
- Select records where date is the last day of month
- Elaborate details regarding unable to restore 2000 Bkup in SQL 2005
- fetching week from thye month.
- StreamInsight
- Building Operational Data Source(ODS)
- Help with syntax errors.
- Reading databases across servers in MSSQL 2005
- Migrating MS SQL DB to New Domain
- migrating same data twice should be restricted
- Select Question
- AD Username Change not working in SQL Server
- Creating Copy of Oracle Table on Local Sql Server
- Totally lost with SQL 2005
- How to protect your SQL Backups
- converting data type DBTYPE_DBTIMESTAMP to datetime
- calculating number of days from the current month
- Re:Doubt In Sql Server 2005
- Creating A Time Duration Field
- xp_cmdshell proxy account
- Quotes around the data exported in bcp command
- Quotes in file exporting out of a SQL database into a CSV file
- Transaction Atomicity in Sql Server 2005
- want to change my hosting server
- Find out Product Sold
- Need Help installing SQL Server 2005
- having trouble creating full-text catalog
- Rebuilding Indexes?
- Drop a login and all associated users
- How to know when you have too many indexes?
- Help - Partitioned View
- Data deleted - how to tell when? (using .bak and .trn)
- Creating a supervisory database for several installation worksites.
- RENAMING database name
- slow access times?
- Denali (SQL Server 11) CTP 1 Released
- Error - 2147217871
- CrossTab Query In SQL 2008
- table scan
- covered query
- finding differences in similar databases across multiple instances
- Best way to set up SQL Server?
- How to create a large database and populate it
- What do you use for DB deployments (to QA, Stage, Production)?
- How much log disk space should we plan for?
- SQL Server Express '05 on top of SQL Server '08 running as mirror?
- Copy table data between non-linked servers
- Help in stored procedure
- counting repetition
- riddle me this (sql 2008 edition question)
- Insert time and Date
- Cases with IN statement
- Getting only newest record on join
- create proc with execute as
- Asset Management: Converting form Excel Spreadsheet to DB w/ Microsoft SQL Server
- Datetime Coversion to 12 hour format
- Broken design or simple query issue?
- Tricky select stmt - help
- Trouble with large query
- How to Merge Sql2000 & SQL2005 Table Data
- update query
- Archiving and deleting script
- how to merge the values of a particular column?
- What to consider when moving MSSQL 2000 from Data Center to Amazon EC2?
- web page opened by job
- Anyway to find out the last time a proc was called?
- get last record
- data Cleansing-standarizing column,s data
- result of ssas database in sql server 2008 management studio
- How to get vaue of last row inserted?...
- variables in WHERE clause cause massive slowdown?
- does adding TOP to select speed anything up?
- how can i find the parameters in dinamic sql statement
- powershell WMI error
- How to Create a trigger for a table
- Turn On Identity seed by sql command
- Mirroring from 2005 to 2008
- SSIS with Linked Server to Sybase ASE 15
- Quick query help
- Designing Project
- Issue with snapshot replication
- Help with Running Total
- Distributor issue
- Query Help
- Format vs Convert
- Replication of VIEWS in sql 2005
- How to Export database in Sql server 2005
- Small DB project
- storing Stored Procedures in version control - ALTER or DROP / CREATE?
- How to output results to multiple files limitted by row count
- XML files
- updation of data in every 7 days
- Seems Soo Typical JOIN
- IF statement in WHERE clause
- SQL XML syntax
- Sequential number UPDATE query
- migration of details from excel file to database
- Date comparisons using parameters --- forward slash is interpreted as divide :(
- Blank entries are treated as zero in comparisons
- Stored Procedure Failed, but kept running
- Need some HELP
- Created csv, but how can I specify data as INT instead of VARCHAR
- 2 keys
- I didn't record the submit date
- Subquery return more than one value error
- Moving from SQL server 2005 to 2008
- Storing filenames of images in db vs actual image
- Run Bulk insert in a cursor?
- data in RTF format to ASCII
- Pivot View
- query help needed
- allow access to 1 view only
- MSSQl 2008 70-432/433 Study Material
- how to add 100 columns at a time
- Create new Function... "Invalid Object Name"
- Password Protecting Sql Server MDF Files
- I asked a new coworker why they don't backup the DB, he said it is too big(!)
- 0 rows, conversion error
- Openquery using a system function
- Add column/update existing rows
- Migration option from MS-Access to MSSQL
- SQL Server Monitoring tools?
- Time out error in mssql
- Service Pack Differences
- i want to lsit the sql code of queries executed by an user
- Create full backup of SQLServer database with data (rows) in tables
- Update a DB via web
- SQL for YTD Calculations
- Login failed for user ''. Reason: Failed to open the database specified in the login
- SQL Query update
- MS SQL connect with Matlab
- Displaying All rows
- Database design query
- SQL query help
- calling stored procedure
- Connection problem with 2008 R2
- There should be a simple table partitioning solution to this problem
- I inherited this report , it’s a way above my head
- Security: Front End vs. Back End
- Copy data from one table to another
- How do you create a constraint to ignore duplicate inserts without throwing an error?
- Permission on ms sql 2000
- select case select
- SQLServer 2008 R2 HA
- how to solve production mssql server 2005 Bulk insert error
- Microsoft SQL Server Management Studio Question
- Hiding the white space when individual cells are hidden in a table
- To update record w/o changing date/time value
- How to interpret showplans
- Need query help
- Updating FK due to dupe records
- Create new fields from distinct data in fields
- Multiple tables/joins
- Percentaje of Clients Number by Region
- Transaction Failed to Block Process?
- Distinct merging multiple values from same field
- Temporary Tables
- return the value of the 5000th record in iteration
- SSIS, importing all sorts of characters
- UPDATE QUERY TAKES MORE THAN 5 Hrs.
- Any way to avoid prefixing N character for unicode
- Reporting Services Issue (SSRS)
- Reminder for users
- Stored Procedure Return Data Type
- Split and count query?
- Multiple Filters in Dynamic SQL = Big Ouch
- selecting sequence
- Have a major issue with Identity Specification...
- About Microsoft SQL Server
- How to return current status from a stored procedure to my Vb.Net program?
- Sql Server Agent failed to executed a scheduled bat file that contains sqlcmd command
- Many-To-Many Relation: Getting Missing Data
- Alter VIEW
- deleting
- Import non-english data from Excel sheet into MS SQL 2005
- Issue with connecting to sql server 2005
- multi-threaded from with tsql?
- Types tables?
- Returning a current and Previous value together
- How to take a back up?
- H/W regarding datetime command
- sql select sum query--urgent help.
- Parameter in select statement
- How to say something is equal to anything
- Validation and varification?
- changing the name of a table
- two child tables should they be one or no
- primary key
- Moving Replication to a new SAN
- How to properly use a lookup table
- Need help with sql
- Foreign key blues
- Shrinking the MSDB logs
- which database should I use?
- is Table partitioning the answer?
- Importing XML file getting an error [SSIS]
- CRLF - how to achieve this when inserting data from a web form
- Moving the ReportSever DB
- find records with more than 3 decimal points in field
- Database Mail failure
- Unmatched Rows moved to another table
- Match a full column to a part of another
- Silly question (regarding insert)
- Newbie OSQL question.
- what method will give the best performance?
- Do i need to give return statement in procedure while inserting values in a table?
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.