Home : Bytes IT Community / View Full Version : MS SQL

Pages : 1 2 3 4 5 6 7 8 9 10 [11] 12 13 14 15 16 17 18 19 20 21 22 23 24

  1. top n percentage
  2. Problem faced in Join(T-SQL)
  3. What is purpose of semi colon after procedure name
  4. UPDATE/INSERT to make One-to-Many table become One-to-One
  5. How to convert datetime to DATE '1936-04-13 07:00:00.000'
  6. log shipping - synch
  7. Restore latest backup and logs
  8. SQL Server only use one cpu
  9. How do your keep text formatting when you insert it into database
  10. problem returning rows from SPROC
  11. SQL UPDATE Database from Excel Table
  12. Rows to Column Names
  13. Stored Procedure vs SQL huge difference in execution time
  14. Upgrade Wizard
  15. Missing Program group
  16. Sort Expression as Store Procedure Parameter?
  17. SELECT works but UPDATE fails. ?
  18. Printing query results from sp
  19. binary_checksum and validated software environments
  20. checksum_agg and row size error. Require explanation.
  21. Loading Flat File using DTS
  22. Stop replication of deletes
  23. SQL Server license checker
  24. Can someone tell me what's wrong with this code?
  25. SQLTransaction locking up table
  26. Getting Data from a storeed procedure in a stored procedure
  27. query in dataview.rowfilter
  28. How to add a foreign key constraint using the SQL server 2000 enterprise manager
  29. SQL Server Performance and permissions
  30. New to merge replication - simple scenario......
  31. Case Insensitivity
  32. Port Fowarding or VPN with Linked Servers
  33. Import schema into SqlExpress
  34. My first trigger
  35. Is Cursor Best Way To Go?
  36. EMC Replication Manager long recovery time
  37. table/index and page mapping
  38. passing parameter
  39. Cannot use TEXTIMAGE_ON when a table...
  40. SQL view / joins query
  41. SQL server - 'cold' database clone, was this ok?
  42. Restore Problem
  43. SQL query in vb.net
  44. SQL Connections with VB.NET
  45. How to find transposed data and near misses
  46. how to determine dbas?
  47. current date/time formula
  48. Incrementing number in a column -- rookie sql user
  49. Finding a column in a database
  50. sql server and vpn: performance/speed
  51. ODBC driver for MySQL does not work properly after version upgrade
  52. Code in the database or middle tier (the CLR controversy)
  53. Script for adding fields to table
  54. stored procedure and if exists
  55. dates issue
  56. clustered index on composite primary key
  57. QUERY HELP: Selecting distinct for two columns group by one
  58. Tx Log Truncate and Deadlock
  59. Giving Active Queries Priority
  60. Filter Expression
  61. sqldmo ListAvailableSQLServers crashes
  62. Need help returning a null value, please
  63. text or varchar ?
  64. Query to compare table data between Test and Production?
  65. Set READ UNCOMMITTED (dirty read) at login.
  66. Problem to Run DTS from Stored Procedure
  67. datatime error
  68. Logic problem in cursor/SPROC
  69. Question: ODBC Connection Error .. multiple thread (urgent, pls)
  70. Creating index on a view to prevent multiple not null values - Indexed view?
  71. Blocking
  72. Need an allround DBA (development&Admin) in MSSQL and Oracle
  73. Can't install MSDE
  74. Column name in functions
  75. IF SELECT UNION
  76. ADO Error Code:0x80040e4d
  77. One-to-many with a twist
  78. Problem with DateTime and strings in stored procedures
  79. SQL Server Database Comparison
  80. sa Vs sysadmin login
  81. log-file for interface-use
  82. deadlock
  83. Stored procedure fails execution sometime
  84. tips on securting sql server
  85. How to delete a big amount of data
  86. system time on sql server is wrong?
  87. What is the right value for BCP's ROWS_PER_BATCH
  88. deadlocks
  89. Change SQL Server Authentication Programmatically
  90. Can MSSQL load a tab delimited text file?
  91. SQL Server Express
  92. Encryption and "WHERE encrypted_column LIKE"
  93. Getting Plan of previously executed Queries
  94. SQL Memory Issues - Need Advice
  95. Help Needed With Job Scheduling
  96. displaying a table
  97. SQL Automatic Growth
  98. Displaying database name within select within UNION
  99. Doubt to be Clarified
  100. What's the difference? Unque Constraint and unique index, etc.?
  101. Need some help with design of tables/views
  102. Db Owner
  103. Setting password for each database
  104. Upgrade from SQL Standard edition to Enterprise edition
  105. ACCESS 2003 query size high problem help
  106. Restore master database from 64bit sql server to 32 bit server
  107. Converting Text to Proper Text in SQL
  108. Increase number of process(thread)
  109. Writing multiple queries to a file with BCP
  110. Help with SELECT please
  111. Concurrent queries error
  112. Permissions with views and tables
  113. some sort of cross tab query in sql
  114. getting a stored procedure's code
  115. Find similar strings in two tables
  116. Error While Reindexing Job
  117. EM
  118. Creating a DB by restore - problems
  119. Multiple SQL statements in a stored procedure
  120. Help with SQL Query
  121. Sql Server incorrectly functioning
  122. retrieving backup
  123. BCP fmt and Create Table
  124. VALUE IN FIELD NULL OR VOID STRING!?
  125. URGENT - DTS - Need to run the object to perform the operation - Exception Access Violation
  126. Trigger Error
  127. Passwords in Sql Server 2000
  128. Create table from Text
  129. Proportional fill
  130. sql server transaction syntax help
  131. Locking an MSSQL record with ADO.NET
  132. setting remote path for "text file (source)" - DTS
  133. sql 2000 with windows 2003
  134. DTS
  135. Display Image Datatype from a table in Reporting Services report..!
  136. what is the true definition of catalog table?
  137. Backup Help
  138. SQL Union / Intersection
  139. DBs not appearing in query analyer dropdown
  140. Selecting Min/Max over multiple rows
  141. Heterogeneous queries
  142. Easy way to remove international alphabet from all rows?
  143. Help with the Security/Login/User area of operations
  144. Suggestions?: Querying tables from multiple databases
  145. how to continue on error
  146. Returning a count of items including zero
  147. update sql errors using linked server
  148. Crystal reports - maximum group total??
  149. Insert performance different between two servers
  150. SQL Injection Attack
  151. Forbidden access to ReportServer (error 403)
  152. Subquery in case statement
  153. Joins on UPDATE
  154. Copying Database from 2000Server Machine To 2003 Server Machine
  155. SQL Job failing error 8198
  156. Collation conflict isssue
  157. How to reclaim space in columns changed from nvarchar to varchar
  158. personal edition then move to enterprise
  159. Test
  160. bad page ID
  161. Foreign key constraints?
  162. Compare SQL objects
  163. CS vs CI database
  164. Network Restoration Of Database
  165. help with for xmp explicit
  166. Cant use ODBC data source on SQL SERver 2000 sp3a named Instance
  167. Order Schedule.
  168. Problem linking tables
  169. Informix Date Function Equivalent
  170. Delete Duplicates
  171. Using IN(xxx, yyy) with table row
  172. Update question
  173. MSCS SQL2000 Cluster 64 and 32 bit servers
  174. Conversion Error...nvarchar to Datetime
  175. Data Comparison
  176. Query Analyzer on 2003 WE
  177. Procedure Encryption - Any side effects?
  178. Restore database April CTP 2005 Failed?
  179. Sql query help
  180. SQL Query Analyzer Greyed Out
  181. How long is a SQL statement allowed to be?
  182. SQL server 7 physical storage
  183. BULK INSERT Question
  184. How to assign quota on a specific datafile?
  185. Updating indexed views - who pays?
  186. Updating SQL Server Database from Access
  187. Adding Active Directory login (ca vs. samaccount)
  188. Checking The User's Server Role
  189. Very Urgent: Required document for R/3 installation on SQL server in disrtibuted environment
  190. Collation problem
  191. A floating point exception occurred in the user process. Current transaction is canceled.
  192. Extended stored procedure performance tuning
  193. creating data for a histogram.
  194. IF...ELSE error
  195. Front Page 2002 and SQL Query
  196. Confusion over "ANY" keyword
  197. Remote ODBC Connection problem \
  198. Service Pack 3 to Service Pack 4
  199. Error 7201: Permissions problem?
  200. SQL SERVER BACKUP problem in different DEVICES
  201. Company-calendars
  202. [Fwd: Reverse pattern matching]
  203. Using EXISTS
  204. Negative values for RowModCtr col in sysobjects tbl
  205. Working with date ranges
  206. Building / Modifying an SQL Database remotely
  207. complexity of nested self left joins?
  208. Changing collation when installing SQL2000
  209. ODBC connection to SQL server failing
  210. Delete recordsets with same Date and Line
  211. SQL Files Query
  212. Problem finding values with aggregate functions
  213. Moving all DTS packages from server to server
  214. Deadlocks & BEGIN/END TRANSACTION
  215. Excessive stored procedure [COMPILE] lock
  216. Bad executed Plan and wrong Result by SQL
  217. NOT FOR REPLICATION, Enterprise manager
  218. Date poition comparison of a datetime field
  219. How to deploy a report in Reporting Services without using VS 2005?
  220. hash table (#) order by problem with more records
  221. Avoid index scan with LIKE and a variable
  222. help with exists
  223. Query Produces Jumbled output / output not in sequence
  224. Compare two databases and update objects?
  225. Will it auto convert datatype???
  226. db_owner to all tables
  227. Which is more efficient, join or straight select
  228. importing from .txt
  229. How to send data from a remote Client to my FTP site
  230. How to send data from a remote Client to my FTP site
  231. How to Copy and Rename a Database: same server
  232. SQL query - highest rated or least voted items
  233. FK on a column to a table where the column is not the PK but a Unique Index
  234. Could not find the index entry for RID...
  235. Script for comma seperated values
  236. Output Select results to a text file.
  237. Storing pdfs in an image field
  238. compare data
  239. ntext and update/insert triggers
  240. A query runs fast in Query analuser but slow in APplication
  241. Cannot start MSSQL Server 7
  242. Insert datetime problem
  243. Why....'PRIMARY' filegroup is full????
  244. insert current date/time
  245. How to insert new rows to master table
  246. storing text data in a binary field
  247. dynamic SQL variable with Output ??
  248. Need hardware suggestions for SQL 2000 server
  249. Basic Syntax explanation
  250. lookup table relationships best practice
  251. Serverwide Rollback
  252. Troubleshooting failed job
  253. Split a field
  254. Insert Trigger to Update table
  255. Date Format Conversion
  256. SQL Syntax - group by and having count
  257. Can I recover from the database files?
  258. BCP and SQL Server 2K
  259. Sending data to a Stored Procedure with ASP error
  260. Theta join or equijoins??
  261. Syntax question
  262. Importing from PL/SQL to MSSQL
  263. How to convert binary or hexa to decimal?
  264. WHERE clause delima
  265. XML Problem in SQL Server 2000
  266. Syntax Question
  267. removing data
  268. varchar only up to 256 characters?
  269. Xquery Support in SQL-Server 2005
  270. equivalent Oracle rownum in SQLServer
  271. Memory leak in SQL Server
  272. Create Second 'sa' Account ('sa2') on SQL 6.5?
  273. SQL Databases compare tool
  274. Need help relocating transaction log file.
  275. C# SQL-DMO ExecuteImmediate
  276. Propagation of event notification when tables are updated.
  277. Which is better for making a copy of a database, restore or DTS?
  278. testing a connection string
  279. Process Info (SQL Server Enterprise - Management - Current Activity)
  280. Slow MDB Linked View
  281. delete last added row -how to
  282. Memory Running Out
  283. Help With Some SQL
  284. Global temp table permissions
  285. How to restore database to point in time (no full backup)
  286. time from datetime
  287. XP_SENDMAIL problem after windows trust with exchange server established
  288. xp_sendmail problem
  289. SQL Server 2000 2GB memory limit?
  290. Formating Numbers with Commas
  291. How to synchronize 2 tables on different sql servers
  292. Constructing Email message
  293. SQL Replication
  294. Does DB-Restore on a different machine omit user/login information ?
  295. SQL DTS package to process a remote OLAP database
  296. How To set delimeters and text qualifiers in a file
  297. How To write An Sql Crosstable Select statment
  298. Using DTS to move data to a new table with some datatype changes
  299. HexToInt, vbintoHexStr - fun with CAST
  300. how to add 1 to the field
  301. Help with SELECT Query
  302. Is this correct use of INSTEAD OF Triggers?
  303. Tunneling enterprise manager over https ASP.NET?
  304. Conecting over the Internet for getting data from clients.
  305. Number Data Types...
  306. openrowset - problem in reconnecting to oracle
  307. Help ! Database Still says loading after restore
  308. Select JOIN problem
  309. Wrong syntax in where smth in case ?
  310. Query Analyzer Template files, object browser bug
  311. wil s2k developer edition really work on XP Pro box?
  312. SQL Profiler
  313. DTS of data between two tables, same field names but differnt datatypes
  314. Sending external email from within a Scheduled Job
  315. What is purpose of N in SQL examples?
  316. cursor insert with like '%'
  317. DTS vs Datastage or Informatica
  318. Connecting for entire session, or just when performing an operation?
  319. How do you lock an entire table?
  320. Crosstab queries
  321. User interaction with SQL
  322. BULK INSERT row terminator
  323. Help Please - Backup FileGroup and Restore
  324. MDX Query Book
  325. Stored Proc not updating multiple rows
  326. DBA on mulitiple databases
  327. 7.00.1078_enu.exe on msde
  328. Problem returning a datarow
  329. Storing binary files in MS SQL 2000
  330. simple SQL update
  331. How can I INSERT w/Constraints in other tables?
  332. SQL 2000 - 450+ Databases
  333. Loop through a recordset to populate columns in a temp table
  334. HexToInt and HexToSmallInt
  335. update from ...?
  336. SQL update statement in VB
  337. Field not being updated within Stored Procedure
  338. Complicated SELECT Problem
  339. Book and class
  340. How to delete rows in a table when no primary key is defined
  341. Primary key
  342. Database Modelling in UML
  343. Mails are stuck in the Queue Folder
  344. odbc errors on terminal server
  345. XML to View
  346. SQL problem
  347. DTS package doesn't execute
  348. Totally shameless self-promotion
  349. Sql server authentication not set
  350. Error while running xp_cmdshell
  351. timeout expired w/SQL2K SP3
  352. any SQL guru's out there?
  353. DEFRAG disk drive
  354. Need good idea
  355. Problem using CAST with Zeroed out Field Values
  356. How can i get the details of the error
  357. Very large number of rows
  358. Will MSSQL DB Server perform better with 2k3?
  359. Database design, inherit
  360. How to get the status?
  361. User-Defined string Functions Transact-SQL
  362. Changing the default port number and still connecting
  363. Need advice for process of swapping DBs
  364. How to convert recursive function into recursive stored procedure
  365. Crosstab query
  366. Database Backup Security
  367. Separate an And/Or parameter
  368. Best way for a Set-based query
  369. Recovery and Backup
  370. ODBC and MSDE
  371. Customer IDs without identity
  372. SQL Server -> MS- Access VBA
  373. persisting data for a pluggable tree
  374. What hardware to get?
  375. generating auto sequential numbers
  376. case, joins and NULL trouble
  377. PRIMARY Files
  378. Install Client Connectivity (SQL Server 2000) Only w/ Less Files?
  379. Write only database
  380. sp_elpuser rights
  381. Mail Profile disabled in SQL Server Agent Properties
  382. Linked Servers - Postgres 8.0.2
  383. Ignore Triggers
  384. checking success of a request in a stored procedure
  385. Session State InProc. HELP??????
  386. can't print variable
  387. Timeout Expired Error
  388. Monitoring Data file size
  389. don't permit manual access to database
  390. Splitting of database
  391. Frontpage 2002 & passing an SQL variable
  392. Snapshot replication
  393. SQL - query improvement MAX(date), IN
  394. Problem with dbo.sysindexkeys in SQL 2000
  395. Creating a trace file with the date appended to it's name
  396. Help with DTS script
  397. SQL Server & MSDE on same machine?
  398. Linking Two SQL Servers
  399. Can I ghost an SQL server?
  400. Tables get Locked
  401. Count of related records??
  402. MS SQL 2005 Express
  403. Net Send Failure
  404. Monitoring Deadlocks
  405. Best way to create dynamic update statement
  406. Job openings for scientifically-oriented programmers
  407. Edit .mdf database
  408. importing a .txt file
  409. SQL Backup procedures...
  410. Installing MSDE2000 for Remote Connection
  411. Noob: Why does this Query work?
  412. concatenate where clause
  413. Moving db across the country- full copy, then differential?
  414. Inserting Records with limited privileges
  415. Scripted delete rows
  416. SCOPE_IDENTITY with ASP
  417. A query that chooses non-matching items
  418. Counting based on a field combination
  419. SQL Server Hot Fix Install Error - dbmslpcn.dll is WRITE LOCKED
  420. Enterprise Manager Collision
  421. Views Are Deleted
  422. quey help
  423. Storing a month
  424. problem with OUTPUT params in Stored procedure
  425. not exist in place of outer join
  426. Dates incorrectly being saved incorrectly. DD and MM swapped round ?
  427. Primary key on combination of nullable fields, at least one not-null
  428. SQL statement
  429. create database at shared hoster site
  430. SQL datetime from incorrect char(10)
  431. Refresh data from production to development
  432. Interesting Problem
  433. SQL Server on Windows XP Workgroup
  434. paradoxical query results?
  435. Int versus Char primay key performance
  436. Tables seem too big - timeouts happening
  437. SQL Server Distribution Server Licensing
  438. SET FMTONLY being added to in-line SQL
  439. Proyectos de Inversion en IT en la UTN
  440. what does [dbo].[Accounts] mean?
  441. web hoster only allows 1 sql server database
  442. problem in registering sql server in enterprise manager
  443. query result as comma-separated list
  444. Last edit time?
  445. Installation Issue
  446. compare
  447. Question with filegroups
  448. I need help connecting Access 97 to SQL Server 2000
  449. IsNull Evaluation within EXEC
  450. Parameters in Reporting Services
  451. Database Environment Naming Production -vs- Development
  452. restore from command line
  453. SQL to find short, fat and stupid people
  454. Strange Problew with user defined function or stored procedure
  455. Get lowest date
  456. How to reinstall RS Standard Edition on top of expired RS Eval edition
  457. Format display of current row
  458. Connecting Access Front End to Remote SQL Server
  459. Connecting Access Front End to Remote SQL Server
  460. Modifing the row that invokes a trigger from within that trigger
  461. instead-of trigger and contraints
  462. Advantage of Temp Table
  463. VBScrip Type Mismatch Error
  464. Diagram of Master DB
  465. Linked Server gives Internal SQL Server error
  466. prevent DELETE and/or UPDATE
  467. binding SQL server to localhost?
  468. Would you please suggest a good backup tape drive?
  469. Cache HIT ratio problem
  470. Verify dynamically specified table exists
  471. command line
  472. DBA HELP: Performane Tune SELECT, SUM, & CASE
  473. QA tells me my table is ambiguous
  474. Breaking up a Table
  475. Call DTS package from VBA/Excel?
  476. query analyzer returning messed up data
  477. MS SQL Server 2000 / MS Access - ODBC connection question
  478. Lost My Diagrams
  479. New SQL Server and Photos
  480. I dont have any backup of my database, but I have the mdf's and ldf's files
  481. How to get parameter passed to SQL query from access
  482. Creating a view from a linked server
  483. How to comment a server template
  484. How do ITables moved to a new FileGroup ?
  485. Sum of hours by week
  486. Destination Columns Question
  487. Remote access to sql database...permissions
  488. Using MSDE and moving databases
  489. Help! Cygwin X slows down Query Analyzer
  490. How to copy db from test server to local machine running MSSQL2000 Per.
  491. Inserting a record for each separate aggregate (solved)
  492. Import RIS format to SQL Server?
  493. Run DTS in safe way.
  494. Neq to SQL
  495. How to fetch or store a BIGINT using dbExpress and Delphi 2005
  496. Deadlocks in Profiler
  497. DBCC SHOWCONTIG inconsistency????
  498. Access Violation on Saving a DTS Package
  499. Assistance developing Query
  500. Convert variable into dynamic select
  501. Windows groups for SQL Server - what am I doing wrong?
  502. Run DTS package
  503. Primary Key
  504. Move mdf/ldf files for a replicated database
  505. Gather Meta Data
  506. Checking datatypes of a field accoss multiple tables
  507. How to call functions via ODBC
  508. Learning SQL Server 2000
  509. Date problem in SQL Server
  510. Data Parsing in SQL Server views
  511. Changing collation for tempdb and model
  512. Changing collation for tempdb and model
  513. Changing collation for tempdb and model
  514. Design Problem...Please Help!!
  515. Char to Bit
  516. SQL Server Agent - E-Mails
  517. Help with update query linking 3 tables
  518. sp_configure missing - need to allow updates!
  519. Alias has confused me.
  520. sp_configure missing - need to allow updates!
  521. time-series SQL code.
  522. Log Shipping Transaction Log Question
  523. 100,000 lock requests/sec
  524. [TRANSACT]Can't switch from master to another database
  525. SQL Server Query Optomizer
  526. "Users shopping for A were also interested in B"
  527. xp_logininfo and Domain Local groups
  528. "Unable to validate product key"
  529. Help with JDBC Driver
  530. Object Owners.
  531. Compare data in Tables
  532. MS SQL Server 2000 Log Shipping problem
  533. Getting error c:\windows\system32\odbcad32.exe error
  534. International Motivation Survey
  535. Need one Query to obtain results I can only get with two queries
  536. Transaction Replication & Data archiving on SQL server 2000
  537. SQL gurus, please help
  538. Connection problem from Access front end application to SQL Desktop Engine backend
  539. Strage characters displaying in Enterprise Manager 2000
  540. Return Type of COALESCE?
  541. Strage characters displaying in Enterprise Manager 2000
  542. Using DTS Global variable in task
  543. Creating a Select statement with subqueries to 3 other tables...
  544. SQLDMO - Operating System Cannot Run %1
  545. Microsoft Access doesn't support design changes to the version of Microsoft SQL Server
  546. Seaching mulitple fields?
  547. Importing txt files with sql server 2000
  548. Do's and Don'ts of SQL
  549. Reorganize data and index pages
  550. Unhandled exception in mmc.exe: : Access violation