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

  1. Project Management Knowledge Base !
  2. sql squeries
  3. Query with different WHERE clauses
  4. sql queries
  5. Truncate text in table? (ie 101928494 will become 928494)
  6. SQL Server 2008 Final release date
  7. relationship
  8. sql queries
  9. not showing proper datetime in tables
  10. sql server queries
  11. plz suggest me the query
  12. IT auditing tool SC Magazine Review
  13. Creative query assistance needed
  14. How to find out difference between two rows....
  15. SQL Server Engine Downgrade
  16. SQL 2000: Transport-level error on SELECT statement
  17. dropped tables
  18. Trying to insert a zero, its telling me i cannot insert a null
  19. A Question on query efficiency
  20. How to deploy a database on SQL Server Express 2005
  21. Can Analysis Server and Report Server run on SQL Server 2000 Cluster
  22. Jobs, Interview Questions, Certification, Knowledge
  23. Re: SQL Server 2008 caching
  24. Re: SQL Server 2008 caching
  25. select blocking sessions t-sql
  26. Write "Messages" window to a log file?
  27. Deduping
  28. Yellowfin seeks resellers for BI product
  29. load_file and blobs
  30. Using a Trigger to determine when a column was changed
  31. Data returned by SQL Server ODBC driver is not correct
  32. Certification in Mind???
  33. Only 90MB for SQL Server 2005 on a Windows 2003 64bit 12GB System
  34. Finding duplicate records
  35. SQL 2000 DTS tool - 256 char limit?
  36. Linking Windows SQL Login to user database
  37. Calling Commonly Used SQL (reusable code)
  38. Export to Excel, exclude header
  39. Can a dropped table be recovered?
  40. How to show field that not being group
  41. Softclarity Builder
  42. Accepting wildcards like % in input parameters of stored procedures
  43. Distinct Row based on description count
  44. Re: problem with column alias
  45. Re: problem with column alias
  46. just u click make a money online
  47. Having problems using BCP for CSV output
  48. Re: ALTER proc vs IF EXISTS DROP/CREATE
  49. ALTER proc vs IF EXISTS DROP/CREATE
  50. Delete Trigger
  51. Intrusion Detection Strategies
  52. SQL Server Scripting Question
  53. sql server query problem
  54. Insert Into Select trouble
  55. SNL Sql
  56. ms sql 2000 - create update script
  57. SQL Query for Dummies
  58. CONVERT() problem
  59. Latest updates in database management and SQL server tools andtechniques
  60. Da MySQL a SQL express
  61. T-Sql & Active Directory Roles, Identification of original login ofimpersonated ID's and Suspended processing
  62. unable to install SQL Server 2005
  63. Re: Best practice on nullability and default value
  64. Formatting datetime when including in a PRINT command etc...
  65. Pb to open an attached mdf file
  66. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  67. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  68. Patch for KB948110 causing random "Could not find database table ID"errors
  69. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  70. How to compile TPC-H ver2.7 on Windows XP?
  71. complicated query (where statement inside select statement, don'tknow how to explain it)
  72. Insurance data models...any tips on good starting point?
  73. Are Deadlocks inevitable ?
  74. Help With Full Text Search. Performing AND across columns
  75. rupdating duplicate entries with random numbers
  76. Changing the name in the ServerName column
  77. Schedule a Query
  78. Multiple attribute design that need to be searchable
  79. Multiple attribute design that need to be searchable
  80. Sql Server 2005 Replication
  81. does this backup sequence commit all data to the database
  82. SQL problem - a variation on outer join
  83. BACKUP LOG questions
  84. Could not execute a package by a scheduled job
  85. dbcc shrinkdatabase
  86. Testing
  87. DB Structure Advice - lots of measurements in DB or file refs?
  88. programmatically stopping and starting transactional replication
  89. login failed
  90. Data loss importing from Excel
  91. transaction log
  92. How do I number an output field consecutively?
  93. Database management and latest updates on SQL server
  94. Re: [ANNOUNCE] Release 1.3 of Mogwai ERDesignerNG available
  95. Cursor among several databases
  96. design issues with large amounts of data
  97. SELECTing from a DML statement
  98. Using UPDATE to sequentially abbreviate address information
  99. Odd character appended to data
  100. Datetime import/export issue
  101. Yellowfin Business Intelligence Release 4.0 Announced to Industry
  102. slow queries for a particular database
  103. sql agent JOB to Backup Database and Maintain Backup Files
  104. Need a script to recreate scheduled jobs
  105. Help needed for Data formatting.
  106. How can I do that using a trigger
  107. OLEDB configuration when deploying multiple SSIS packages
  108. Decimal point and comma
  109. Re: Stop hotlinking to a specific file & keeping a counter
  110. Please Help - Can't check for duplicates
  111. Deploying an app with SQL Server (installation on client machine)
  112. How to secure a database ...?
  113. Can I search for a string in a set of stored procedures?
  114. GROUP BY a computed column
  115. Creating a database from set of TSQLl files
  116. Concatenate in MSSQL
  117. Storing BLOBs outside database
  118. Re: Duplicate Tests - Help Please
  119. Re: Grouping by Day for a Date Range
  120. Question about recompiling a dll
  121. table naming convention about this case..
  122. Latest updates on SQL server 2008 tools and techniques
  123. Computing a column that is a percentage of the sum of another column
  124. Database security (non-existent?)
  125. Tool to chase down the consequences of adding field to DB tables?
  126. Applying tranaction log to old data file
  127. Re: Database naming conventions?
  128. Latin1_General_BIN comparing two char strings
  129. alter table query not working after working at least once. MS SQL2000
  130. Re: Database naming conventions?
  131. Re: Database naming conventions?
  132. Transact-SQL for Restore Filelistonly using a variable
  133. Toad for MSSQL problem: closing script file doesn't "release" thefile?
  134. bcp out in UTF-8 format
  135. Kuljetusalan ongelmista
  136. Basic SQL Statement Question
  137. Differences between relational DB and warehouse ?
  138. tbl_A CROSS JOIN top 1000 rows of tbl_B?
  139. bcp out empty string into csv files
  140. C++ API for SQL Server?
  141. SQL 2008 EULA and pricing
  142. SqlBulkCopy.WriteToServer() blowing up on tables with Identitycolumns
  143. Performing multiple bulkcopies for different tabels
  144. stored proc with datetime
  145. Forget about Referential checks??
  146. Re: Not finding GUID value after migration sql 2005 to 2000
  147. bulk insert in clustered index table
  148. Re: Vaalirahoitus (oli: Re: Irlanti pelastaa Suomen)
  149. database design
  150. Re: Not finding GUID value after migration sql 2005 to 2000
  151. DB migration
  152. Newbie basic questions
  153. HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers ,
  154. Anyway to declare and use variables in a View
  155. MSDE upgraded to SP4 but showing SP2
  156. Select from a access table
  157. Migration of an Access Database. How is the best way?
  158. Problem connecting to SQL Server from Access Database
  159. simple SQL engine
  160. Fuzzy logic for duplicate identification?
  161. Full text search in albanian
  162. database owner?
  163. Convert Int to Date
  164. IF within SELECT
  165. live online training
  166. Re: "Maksanhierontalaite" ; )
  167. Problem With View and Changing Field Length
  168. stored procs
  169. Looping Through the Records returned from a DTS Lookup
  170. Snap-in failed to initalize.
  171. Compound vs Simple Indexes
  172. Re: Ruuska
  173. Not an ad hoc query?
  174. Stored Procedures and Commiting Data
  175. Connect problem
  176. Dell c610
  177. Re: search pyrkii nettiin
  178. Using Case within Select
  179. SQL 2005 report deploy issue
  180. Is this a correct table structure for my database?
  181. How to find if instance is cluster or non-cluster
  182. SQL Server 2008 - Filestream
  183. Error running DTS script in VB
  184. SQL->RDF? Best question about semantics technology wins admission to LinkedData Planet
  185. How do do a query against hardcoded row values
  186. Need SQL Server Dasbase Admin
  187. simple ALTER Table query question...SQL 2000.
  188. Disabling Triggers
  189. Installing sql server 2000 on windows server 2008
  190. Update Query Runs Forever
  191. Re: Outer joins in MS SQL 2005: why is it this way? better yet, any resources on these nuances?
  192. How to sell sql skills? (Need your knowledge and thoughts)
  193. (Newbie) Join problem.
  194. Problem with joins in SQL.
  195. where do I download sql odbc drivers from?
  196. Re: Connection pooling issue with pass through queries
  197. Join zero padded char to varchar
  198. Re: Connection pooling issue with pass through queries
  199. Re: Strange select
  200. Re: Strange select
  201. Re: Need Help With an Update Script
  202. strange Problem
  203. your thoughts on this please
  204. SQL Server 2000 UDF Intermittent Slow Execution
  205. Sysmergesubscriptions question
  206. examples with SS2008 -xEvents?
  207. Need Help With an Update Script
  208. delete a named instance - how?
  209. SQL Server Browser service?
  210. select from two tables
  211. Strange connection problem
  212. Help with an Update Statment
  213. Install new instance...
  214. Simple Query Question
  215. Where's my instance???
  216. DBMS advantage and disadvantage
  217. Rename Default Instance Name SQL Server 2005
  218. Cannot Read Varchar(max)
  219. relocating Outlook Business Contact manager
  220. confusion over indexs via primary key and clustered index
  221. Link to external file
  222. SQL Excel - freeware add-in for excel
  223. Modeling/Constraint question
  224. Email Generation from within SQL/Server 2005
  225. Re: SELECT Optimalization
  226. Best pratices to manage the "same logical" database on multipledatabase engine types (postgreSQL, SLQServer, etc..)
  227. Help with SQL Backup Problem
  228. DTS Transfer Data Task - output to text file with field names infirst line
  229. I want to update the column in a table based on the updation of theother column in the same table
  230. syscharsets unicode
  231. nested stored procedures and returning lots of rows
  232. Checking for duplicates in a database table
  233. firewall rules for SQL Server
  234. Modifying registry information to change type of login logging
  235. Suggested DB Reverse Engineering tool...
  236. Local Security Policy - Restricting Access
  237. Cursor and Procedure
  238. select from row1 to row n
  239. Reattaching database - identity_insert set to off
  240. Most Helpful Professional Award
  241. Cross Database Select
  242. Merge process could not update the list of subscriptions
  243. a and (b or c) better than (a and b) or (a and c) ?
  244. caching table Problem
  245. How to return a Pk value from one stored procedure to another storedprocedure
  246. create dynamic variable in procedure
  247. Advanced SQL Cubing
  248. SQL 2005 on Windows Server 2008 - Slow Connection Time
  249. Re: Display duplicate rows
  250. Help!
  251. Re: comp.databases.ms-sqlserver
  252. Altova v2008r2
  253. Urgent: Deciphering binary code executed against the database
  254. copying row from same table and adding value from form.request
  255. Doing a SELECT INTO using a Stored Proc as the data source
  256. SQL Statement Problem : Separate long varchar into word seqments 35chars long
  257. Setting SQL Server Agent Account without being part of a domain
  258. Limiting table access using stored procedure.
  259. SQL Select All Items where one meets the criteria
  260. optimal selection of all records for a certain month (illegal datesOK?)
  261. updating multiple columns with subselect
  262. Selecting several types
  263. Prevent Excel and Access access to SQL 2000
  264. Read HTML File though Network for Email.
  265. Disable and Rebuild or Drop and recreate Index
  266. Force protocol encryption on hosted database
  267. How to implement Audit/Alert for Row level access?
  268. Orphaned tupels, should I clean or is it ok to leave?
  269. Full text indexing scheduler SQL Options
  270. SQL and Database Design newsgroup
  271. ASP.NET 2.0 not connecting to SQL Server (not web.config)
  272. Help with bbrowser cell focus ?
  273. Client applications
  274. Re: SELECT * vs SELECT col1, col2
  275. COLUMNS_UPDATED() with triggers
  276. Re: How to show Median in a GROUP BY clause? (AVE works, Mediandoesn'
  277. beginners question...
  278. Conditional data copy SQL Server to Oracle
  279. Can you tell who last edited a SProc, and when?
  280. Select CASE returning NULL value
  281. Why freetext query become very slow all of a sudden
  282. Select date in british format
  283. back up jobs, re-index question
  284. MSSQL - MySQL
  285. file crawler
  286. How to recover deleted records?
  287. capture and save running sql query to database table (for logging)
  288. Use of having with additional select
  289. design question - type heirarchy with supertype queries
  290. Performance question concerning varchar(max)
  291. Yet another basic SQL question
  292. using LEN to find a first word greater than 17
  293. Job ends successfully even when it's not true
  294. exporting a table with long field names to Access
  295. Basic SQL Question
  296. FAQ & Solution: How to generate a number automatically for thePrimary Key when inserting a record?
  297. Another new DBMS
  298. copying data from one server to another
  299. How to find records with length greater than 17
  300. CHECKSUM to determine record changes
  301. first minimum date in the column for each distinct column a value
  302. Re: Get rows whose sum matches a value
  303. The Sql ranking OVERture
  304. sp_prepexec syscomments?
  305. select parent records that do not have a particular child
  306. how to create my own primary key which auto-increment
  307. Re: Get rows whose sum matches a value
  308. Re: tempdb size question
  309. Re: HELP WITH SELECT STATEMENT PLEASE
  310. SQL Server 2005: functions become slow after a while
  311. How to get the sql statement of a view? (by running a query or from ado.net)
  312. Granting permissions for a user from another database
  313. Login Seems OK but doesn't behave correctly
  314. table trigger just hangs
  315. SQL Server Management Studio
  316. Dump table as INSERTs
  317. Query Japanese Text in an NVarChar?
  318. SQL 2005 XML Searching
  319. import ADO DLL
  320. Performing Bulk Load of XML Data
  321. case-when error
  322. Secure Auditor, 30 security tools at the price of one.
  323. Secure Auditor, 30 security tools at the price of one.
  324. Finding "missing" rows
  325. Login failed for user 'sa'. Reason: Server is in single user mode.
  326. Re: T-SQL Duplicate Record Help
  327. Connection String on shared server- Almost there but need a littlehelp
  328. Please recommend SQL book with excercises
  329. Re: default value wich is not in DDL.
  330. Handle Triggers in MS Access 2003 with SQL Server as Back-End
  331. where do I download sql odbc drivers from?
  332. (Newbie) Join problem.
  333. Problem with joins in SQL.
  334. Join zero padded char to varchar
  335. Constipated publisher (SQL 2005)
  336. PHP/MS SQL - automatic formatting: varchar, datetime
  337. xSQL Profiler - monitor multiple SQL Servers from one centrallocation
  338. How do I make a backup device file smaller ?
  339. SQL 2005: Renamed 'sa' account
  340. Client side insert update
  341. help,a regular text file how to sql 2000 table code ?
  342. Problem Connecting .NET app to SQL Server
  343. An optimum query..?
  344. boot camp
  345. getting tables that link to a table
  346. [IAT ELEZIONI] Presentazione candidati
  347. Simple Concatenation Question
  348. List Columns in a Table in SQL 2005
  349. SQL Assistance required
  350. Error History?
  351. Deleting multiple columns from multiple objects
  352. from 'image' to 'varbinary(max)'
  353. What does it mean to SET a value?
  354. Complex Calculation
  355. difference between explicit inner join and implicit
  356. delete output into <xml column of audit table>
  357. testing if value is null
  358. Internal query processor error
  359. Violation of primary key
  360. CASE WHEN Equivalent in WHERE Clause?
  361. Uninstall SQL 2000 Workstation Components
  362. Scalar Subquery in MS-SQL Server 2000
  363. Scalar Query in SQL Server 2000 like in oracle
  364. SQL 2005 Express - problem with no "SQL Serevr Agent"
  365. SSIS security
  366. converting SQLTable to Excel Sheet
  367. dbrpcparam datalen problem
  368. ADO vs ADO.net
  369. SQLServer - VC++
  370. DLL -> Database
  371. SQL Server
  372. help with DDL trigger. Moved from other newsgroup.
  373. UTF-8 Coding of MSSQL 2005 DB
  374. how to calculate rank in selected records in sql server 2000
  375. SQL Server - synchronizing database changes across servers
  376. Rounding not working
  377. Getting record position in sql server 2000
  378. Deleting Tables
  379. call script from another script
  380. nub question :(
  381. Triggers and Flag bit
  382. IO Completion Listener
  383. Selecting alphanumeric combinations that do not exist already intable?????
  384. Doing Summation on multiple criterias on the same column in a singlequery
  385. Data Type
  386. Table Schema
  387. Data Shifting Between Records
  388. Duplicate key ignored AND statement terminated
  389. Moving SQL 2000 to a new machine by copy-paste !!
  390. SQL 2005 Workgroup Edition - how to run a trace
  391. SQL2005 performance problem
  392. Inserting nothing takes a long time
  393. Your resume is shortlisted - apply immediately | More than 85 TOPcompanies recruiting this week
  394. Can users be connected during a SQL backup?
  395. job died but why?
  396. What privilege is needed to run DTSRUN ?
  397. using fn_trace_gettable on trace files where the path contains aspace.
  398. Trigger to modify a table
  399. Allow Guest account in Windows XP professional to use sql server
  400. Car-Sharing Offered - ICC Birmingham MS UK Product Launch, 19th March
  401. Bigint from a SQL Server table and viewing with Access
  402. Where is SQL Server Enterprise Manager?
  403. MS SQL SERVER DBA/ CONTRACT/ IN
  404. Triggers
  405. help - extracting metadata
  406. osql
  407. DateTime Automatic Formatting
  408. Result Row
  409. Name value pair
  410. MS SQL Trigger to update changes in a record
  411. function to extract delimited data
  412. ssis Bulk insert failed "Received an invalid column length from thebcp client...".
  413. Creating custom Primary Key in SQL Server 2005
  414. Email
  415. copying data WITHOUT DTS
  416. Top companies recruiting this weekend - Apply with updated resume
  417. Exam 70-229 :Designing and Implementing Databases with Microsoft SQLServer 2000 Enterprise Edition
  418. How to decode in SQL Server 2005
  419. How can I format a datetime as 'yyyymmddhhnnss'?
  420. SQL Server 2005 Licensing concern.
  421. Lost Full Text catalog that won't delete!
  422. History Tables: Always Subtables?
  423. Removing 1 hour from text field
  424. Linking error
  425. How can I use variables in this TSQL Statement
  426. query help sought
  427. where is import and dts on sql server 2005
  428. checkbox
  429. windows form
  430. Using findstr on SQL 2005 ERRORLOG file
  431. Transfering data from SQL Server Standard to SQL Server Express
  432. Query - select common data from one column and display in severalcolumns
  433. ado net
  434. Using a "match" table to store multiple columns for parent data
  435. Deleting a maintenance plan
  436. Problem with a lot of inserts in short time - SQL Server 2000
  437. Syntax to access database on another server
  438. reduce time for search query
  439. Error on Transaction log backup
  440. Backup Exec and MS SQL Server 2005
  441. Track changes made to SQL Server
  442. Need help with SQL Server Cluster
  443. Urgent IT related openings with Corporate MNC companies all overIndia
  444. SQL database hang
  445. Query string encryption in T-SQL
  446. DB size increase from SQL 2000 to 2005
  447. SQL question ( retrieving records based on a priority order )
  448. Use unique key for Sqlserver view for updates
  449. Help with SQL Query for Graph
  450. UPDATETEXT question
  451. Inventory SQL Server machines on your network
  452. Why Same query results in two different # in SQL Server vs MS Access
  453. Count from detail table
  454. Want to learn SQL in California....any school, literaturerecommendations?
  455. Freshers Recruitment & Walk-in For Freshers Feb 23-24
  456. Table replication question
  457. Slow performance in SQL2005
  458. Query Plan Tool on my web site
  459. Online Query Tool SQL Server 2005
  460. Log File Recovery.
  461. Problem With SQL UPDATE
  462. SQL Server Performance Issue
  463. Help Needed For writting a query (SQl Server 2005).
  464. CharIndex, Left T-SQL question
  465. importing multiple excel files
  466. Trigger Question
  467. need of SQL Dumps
  468. SQL 2005 OSQL qestion on Microsoft cluster
  469. Adding conditions in the ON clause of a JOIN
  470. Enum the running SQL instances using DMO
  471. Interactive Sort on Matrix in RS
  472. How to check setting of CONCAT_NULL_YIELDS_NULL
  473. Why does Error log show database restarting everytime a transactionlog backup runs?
  474. Urgent walkin interviews from top rated companies
  475. Problems character sets / special characters dot.Net <-> mssql-server
  476. on line discuss
  477. Primary Key fails to copy in db Export
  478. System DB backup Error
  479. Why does numeric data type use storage inefficiently?
  480. Create a new table from csv file using SSIS
  481. Distributed Transactions across Linked Servers
  482. Help in Table level restore/backup
  483. sql server migration issues
  484. Rowlock v. optimistic concurrency
  485. Crosstabbing (or rotating) a sql table
  486. Need help writing a stored procedure
  487. sql learning
  488. autonumber
  489. Transfer data to web page fields
  490. Inserting multiple records into two tables...with a twist
  491. trig errors
  492. Alert doesn't work on SQL 2005
  493. REPLICATION
  494. Select statement query
  495. multiple numbers in one statement
  496. Deploying CLR trigger to SQL-Server 2005 -- Permissions Required.
  497. Rmote database inserts blocking local queries.
  498. Performance issue using conditional WHERE clause
  499. Months Between
  500. Problem migrating DTS to SSIS
  501. Unable to attach the database
  502. Help-VB.NET and SQL Server 2005
  503. NULL values in a SELECT in another SELECT
  504. Query Question
  505. removing unused objects - SQL Server 2000 or 2005
  506. Timestamp Precision
  507. Access 2000 and SQL Server 2005
  508. Stored Procedure to list out user access
  509. I need to know where mssql server stores its data.
  510. TempDB won't shrink
  511. Design question regarding junction tables
  512. Variables in SQL-script SQL2005
  513. sql mager
  514. SQL Sort Problem
  515. duplicate checking
  516. A dimension playing off another dim
  517. Need Help Importing Data from Excel to My SQL Database
  518. Biztalk vs SSIS as an ETL tool
  519. A philosophical question about inserts
  520. SQLServerException: The TDS prelogin response is incomplete.
  521. 16GB Ram 64-bit server, what configuration to use?
  522. T-SQL Sudoku Game
  523. SQL 2005: Transactional Replication > Executing sp on subscribershould execute on publisher
  524. SQL SERVER 2005 SP2 post upgrade issue
  525. error when connecting to sql db
  526. Queries Log on SQL Server 2000 ???
  527. Output to text-file
  528. Formatting Numeric Value in Computed Column
  529. check the word whether correct or not
  530. Create Delete Trigger on Table1 to Update a filed on Table2
  531. [Announce] DataDirect XML Converters 3.1 Released - HL7 Support
  532. using freetds tsql
  533. working with a local db copy
  534. Dropping an active connection on an attached database
  535. Selecting SUM and COUNT, but not straightforward..
  536. DB2 Tutorial
  537. Select Max values from queries for multiple Schedule_Number
  538. Token Replacement in SQL Server - any down side to turning it on?
  539. ? about users
  540. FOR XML EXPLICIT can't get element 4 going
  541. SSIS Mapping Columns from Flat Files
  542. Multiple joins in SQL Server
  543. Error handling in stored procedure AND checking
  544. Active/Active cluster on 2005 - can I oversubscribe RAM now?
  545. Pass through query from MS Access
  546. Position of Table Columns
  547. M I.5'Perse cution ' Capita l Radio - Chris Tar rant
  548. database optimization
  549. backup advise
  550. sorry