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. Difficult Query: is this possible in SQL?
  2. Calling methods, functions threw Extended SP in a DLL
  3. Outlooksoft
  4. Need to speed up query.
  5. Concurrency puzzle (ODBC API related)
  6. Lock Stored Procedure
  7. SQL SERVER 2000 - EXEC master..xp_cmdshell permissions
  8. question about launching an application at sqlserver startup
  9. XLOCK and ROWLOCK
  10. Null & one more table
  11. How to properly restore transaction log
  12. Example code for database configuration(MSDE)
  13. Dynamic SQL trouble
  14. Search Multiple Columns with REGEXP
  15. Development Environment Needs?
  16. Help with NOT EXISTS query
  17. Drop Column problem
  18. Login With Domain Account
  19. Sending an e-mail via SMTP in SQL Server
  20. Aborting CALL to stored procedure
  21. Backup and Restore
  22. SQL Checkers Game
  23. jet to sql
  24. how to get a list of configuration settings for a database
  25. Selecting Unique Record
  26. HELP with TIME Calculations
  27. Eliminating Combinatorial Relationship Multiplication
  28. Slow performance on ADP forms using filter
  29. SQL Syntax problem
  30. howto: calling sp_executesql from a function ?
  31. SQL Data Compare Error
  32. Fundamental help required with SQL connection
  33. fail to configure my server for replication
  34. Help: MS-Word apostrophes in Query Analyzer
  35. Replicating LDAP entries to a SQL Database
  36. Converting MS query to SQL Server 2000
  37. Linked Server request...
  38. I need BETWEEN on speed
  39. Vyas, Neil and others Please post your views ---- SAN , active transaction logs
  40. does anyones knows polyserve products
  41. sp_makewebtask
  42. Multiple many to many
  43. MS SQL 6.5 Procedure to Send Query results via Email
  44. Why the transaction log file full
  45. EMC Clarion Performance Issue
  46. checklist for moving a database from one server to another?
  47. How do I loop thru a result set?
  48. Custom SQL Server Job Schedule
  49. Parameter value from empty text box - null or 0 length?
  50. XML Output
  51. SQL update on multiple tables
  52. PRINT only takes effect after T-SQL completion ?
  53. Invalid character value for cast specification: SQL Server 2000
  54. Data Processing Script Justs Stops
  55. sqlserver7 connect
  56. View performance, linked servers, query specifiying uniqueidentifier
  57. University of Plymouth Computing Industry Perception Study
  58. Guid vs Identity
  59. parameterized queries running slower than non-parameterized queries
  60. Converting numeric data type to text data type
  61. get current table name in stored procedure
  62. PERC RAID Controller settings?
  63. sp_prepexec and compatiblity mode 7: float variables comparing to string field fails
  64. Beginner's Question on SQL-DISTINCT
  65. Database field length problem
  66. xp_cmdshell missing
  67. Running DTS through Access VBA
  68. Using MS SQL server to copy files
  69. Age Old Question about GROUP BY clause (i think) - Probably easy answer
  70. Help with 2 queries / Join problem
  71. Sccheduled packages don't run
  72. MDX Query Help
  73. Help with returning a certain # of records from a view.
  74. The size of the image data type
  75. Write Conflict.. please help!
  76. SQL Server to Oracel
  77. Very puzzling count
  78. Installing SQL Server 2000
  79. I can't restore the transaction I needed! Help!
  80. SQLAgent crash
  81. help how to create a row progressive..
  82. error 'Login failed for user sa', and the backup fails.
  83. Update, case statement and sum
  84. SQL Server ASP Syntax error
  85. DTS Package
  86. Big problem with triggers
  87. Restaurant databases
  88. SQL CPU Utilization goes to 0
  89. SP Technique --
  90. differential backup failure
  91. OT? mysql groups
  92. Deadlock Problem
  93. Modifying Sysxlogins Domain Names in SQL2000, strange result..
  94. Help with SubQueries?
  95. converting date/time to just date?
  96. SP problem with editing records
  97. SQL Server Licensing Question
  98. MS Network Monitor Utility - How to get for Win 2000 Pro
  99. Database Access Right Issues
  100. DBA guide
  101. Read Data from Cube and Dump in a SQL table
  102. Automatically Sort Table when Table is Opened in Project
  103. Vo2Ado/MSDE Create Index problem
  104. Using triggers
  105. SQL instances
  106. Using User defined type instead of varchars
  107. storing phone numbers
  108. SQL Server - Remote Command Line Management
  109. Add a second databse - benefits?
  110. Goup by clause confused....
  111. sql
  112. MSDE 2000 Release A won't talk
  113. No default entries in SQL Server 2000 Service Manager Options
  114. Needs Help in Making Database
  115. indexing
  116. Analyze LDF files MS SQL Server 2000
  117. Comments on InterSystems Cache Database Platform
  118. sql server service pack 3 update, delete question or problem
  119. Determining if a parameter exists in a stored procedure
  120. Looping In SQL 2000 (Can it be a nested loop)
  121. Inserting few Recordsets into Temp Table containing NULL Values
  122. WARNING. A simple cut and paste of 8 records can distroy a SQL Server table
  123. Help with an MS SQL Server Query to return the latest dates against each recordID.
  124. HElp :)
  125. select between date
  126. Update rows with next higher id, if it exists
  127. SQL Server ORDER BY bug?
  128. denormalize data in a temporary table
  129. Web publishing in Visual Manfacturing
  130. Error creating linked server to Excel
  131. Syncing Database
  132. slow select statement -- please help
  133. DTS workflow problem when encountering On Failure
  134. Modelling large trees in SQL Server
  135. Superior SQL Builder
  136. Is this too much data for SQL?
  137. SP Error
  138. query question
  139. Different behaviours on different servers
  140. explain plan
  141. getting an int id from an inserted record
  142. Format File Easy one (not for me)!
  143. I give up on this one...
  144. Bulk Insert Problems
  145. sql date contraints
  146. Concatinating Variables
  147. Passing a specific cursor record to a function
  148. Exporting SQL to Excel Hourly
  149. SQL Server 2000 filling a key field
  150. Non sharing data cluster
  151. No Subject
  152. sp_executeSQL Syntax Question
  153. Bcp and Bulk Insert not working
  154. I need the istance name in my SQL 2000
  155. restore from different server - user (sid) does not match restored db - fix with sp_changeobjectowner
  156. Declare an array of int in SQL Server
  157. INFORMATION_SCHEMA query question: constraint columns
  158. Record lost with UPDATE statements
  159. MS SQL Server -
  160. Alter Table Alter Column
  161. sql insert problem
  162. I/O Component Bottleneck Theory
  163. Fixing my table based on Dbcc Showcontig results
  164. Scheduling a backup
  165. How do you "dump" a database with MS SQL?
  166. Problem with conversion of string
  167. MSDE and Windows 98.
  168. NEED HELP and GUIDANCE!
  169. multiple records, only want one
  170. Example of a University database
  171. Help with multi Join or multi tier select.
  172. DESPERATE help needed....
  173. Complicated Update Statement
  174. Databases Syncronization
  175. SQL SERVER Backup
  176. Where is stored Columns Description for SQL Server Tables?
  177. Sql Server & Java. Book Recommendation.
  178. UPDATEs with multiple aggregate functions
  179. Performance Question
  180. Databases Syncronization
  181. Storing Time in SQL Server 2000
  182. Upsizing from Access Data Type Problems List
  183. Stored Procedure Question
  184. View not working SQLSERVER 2000
  185. archiving analysis server dbs
  186. connection to sql server 2000 from Solaris
  187. OPENQUERY Question. How to update using 2 tables
  188. strange problem
  189. MS SQL Server - a plethora of limitations...
  190. interupt JDBC SQL query connection
  191. Parameter Query
  192. function
  193. Please Help - dBASE
  194. Upsizing to SQL 2K
  195. Restoring Master from Enterprise Edition to Standard edition
  196. # of billing cycles
  197. Computer Books, Inc SQL Server 2000 Books - up to 80% off
  198. Replacing characters in a text field
  199. What's in a full SQL Server backup?
  200. Order by "string not empty"?
  201. Microsoft certification test 70-229
  202. Building dynamic tsql statements in a loop
  203. Problem with LEFT JOIN... please help!
  204. Duplicate Removal and Intelligent T-SQL
  205. Data script
  206. Deleting a record from a VIEW
  207. Need MAX from Each Group
  208. get DB name from within stored procedure?
  209. MSSQLSERVER service terminated unexpectedly
  210. Help with an import to SQL
  211. Problems running Enterprise Manager and Service Manager
  212. Data Retrieval From Online Database - Paid Consultant Required
  213. Media question
  214. Formatfile shortcut?
  215. Bulkadmin role (BULK INSERT)
  216. TOUGH INSERT: Copy Sale Record/Line Items for "Duplicate" Record
  217. question abot primary key
  218. Very serious bug with Materialized/Indexed views and SQL server
  219. Unicode in SQL queries
  220. Unix connectivity tools to sql sever 2000
  221. Table Spool\ Lazy Spool
  222. Database restore question
  223. Recordset opens as read-only -- WHY??
  224. INDEX possible for reverse wildcards?
  225. Altering SQL Server 2000 table design
  226. Large Data Delete
  227. Data Modeling
  228. WriteBak Reaktime examples
  229. Count rows in a date interval
  230. Help with getting table information from sqlserver
  231. query regarding date format
  232. Print list of tables with Identity row set to NOT FOR REPLICATION
  233. OPENDATASOURCE: text file as input ?
  234. Build database application on Internet with ISP?
  235. Operating system error code 3(The system cannot find the path specified.).
  236. Setting maximum number of merge agents
  237. Volltextsuche mit contains
  238. SQL 6.5 with Delphi 1.0 on Win95 problem.
  239. Migrate VIEW from Access to SQLserver ???
  240. Input string was not in a correct format
  241. eliminating redundant data
  242. NULL vs. "Unknown Value"
  243. set a attribute to random values in a given list
  244. Logging to second disk -- what happens when it crashes?
  245. Representing rows as columns
  246. MSDE Maintenance Plan
  247. Comparing data in two consecutive rows from a single table
  248. Sum question
  249. HELP! Shopping Cart Solution Required. URGENT!!
  250. accessing SQL 2000 table from within Excel
  251. Count query problem :(
  252. slow query thousands of records.
  253. solve the proplems
  254. DTS Import not working after SP3a upgrade
  255. Generate a normalized XML doc from SQL Server
  256. Instances of SQL
  257. Nested Coalescing possible in SQL?
  258. Fundamental Functions MS SQL Server 7 or 2000 users VALUE MOST
  259. Control characters output in attachments from xp_sendmail
  260. Convert to Date
  261. Is any possible to run DTS package from Command Line ?
  262. SQL Query - Date, between dateadd problem
  263. wildcards in dropping constarints
  264. Selecting Values in CSV
  265. Advance SQL
  266. Help Required on Stored Procedure
  267. Possible Corrupt Table
  268. Creating roles
  269. can u help with my select ?
  270. cross tab or derived table
  271. Like statement
  272. possibile che ...
  273. Calling All T-SQL Gods & Goddesses
  274. How to Spec a SQL server
  275. SqlServer changes cursor to "read only"
  276. Yet another BCP issue
  277. Scripting "INSERT"s in an SQL database?
  278. Help setting up SQL2000
  279. CASE with empty parameter
  280. multiple result sets
  281. PRINT command Not Working For Database Client
  282. Select lookup code values problem
  283. How to transform fact table only by SQL?
  284. DBCC and Failed Assertion Errors - HELP!
  285. Why is my Data Import going so slowly?
  286. Full-Text Search Query Question - Performance
  287. SQL for Modeling Generalization Hierarchies
  288. Breaking out data from a text field type
  289. Functions with global variables
  290. Who is in a database ?
  291. update tables from a csv file?
  292. connection problem to sql 2000 on windows 2003 from Windows 95
  293. HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET
  294. Whats wrong with this nested while loop?
  295. password protecting data
  296. Problem in Right Outer join query
  297. Defining global function in DTS
  298. BCP utility replaces German with junk characters
  299. Right outer join problem
  300. Advanced SQL Query Problem ...
  301. Problem with a temp table
  302. Timeout / Obtaining a connection from the pool - Please Help!
  303. select into withidentity
  304. question about retrieval of client process IDs
  305. Update Top 30%
  306. how to drop all keys & indexes
  307. last row
  308. Update all tables in database
  309. Disabling primary key
  310. stored procedure result set
  311. last day of previous month
  312. long query alert
  313. changing one column in each row
  314. Access linked to SQL Server - 2 day offset error
  315. FOR SELECT
  316. Embedded select query?
  317. SQL Server makes our server reboot!
  318. Insert into two tables, both with auto increment fields
  319. Sudden xp_send mail error
  320. SQL pieces-parts
  321. Query: How can I get this result?
  322. Adding Identity Column to BIG table
  323. Date/Time select Problem
  324. are nulls bad
  325. Novice question regarding client notifications from a server
  326. Mapping SQL Server Data Types to C DataTypes
  327. Query to get the Domain from the email
  328. script to remove nulls from DB?
  329. Wrong record retrieved after move to SQL Svr
  330. Log shipping wizard doesn't show up in Enterprise Manager
  331. Cretae a view in one DB with a stored procedure from another DB
  332. Sql server-compi question
  333. @local_var really cannot hold table name ?
  334. Which is faster?
  335. Trouble with Update syntax
  336. Conversion Problem
  337. Inserting a select with an additional static field
  338. Correlated Subquery with distinct Record
  339. deadlocks in sql server
  340. Query in a Loop
  341. case-sensitive search in sql 7
  342. SQL Server DB Backup job problem
  343. Log Shipping for replication
  344. Displaying images clarafication
  345. Performance Tuning for Row-by-Row Update Statement
  346. Allow zero length
  347. noob question how to make a mailto function
  348. 3rd party tools for job scheduling
  349. NooB Scripting Question How to use mailto
  350. Date functions
  351. Stored Procedure Across SQL Servers
  352. Using alias in an expression
  353. Spacing problem in SQL Server
  354. Query too slow
  355. Tricky Record Locking Problems
  356. find missing/deleted records?
  357. Book recommendation on performance
  358. Closed transaction keeps running...awaiting command
  359. 1:m database relation "Flattened" for reporting purposes
  360. SQL 7.0 to 2000 upgrade
  361. Performance problems with query
  362. Risks of single MSSQL domain account for mult servers?
  363. sql server 2000
  364. MSDE and SQL Server 2000 design questions...
  365. Mainframe Datatype Scrubbing
  366. Securing mdf file
  367. unable to submit more than 8000 characters with stored procedure
  368. Backup/Restore locks up EM
  369. MSDE and NetUserAdd Error
  370. Analysis Services
  371. Update stmt with an Table alias?
  372. Access vs SQL
  373. Sql 2k Database Log file Full ... How to empty that
  374. Filter Criteria - Temp Table Join or Where clause?
  375. TempDB Disk placement with Log files?
  376. Enterprise Mgr Can Not Sort?
  377. Linking to MS Word
  378. 'Primary' filegroup is full.
  379. Select Max query - please help
  380. Nulls in calculations
  381. Something like MIN(f1, f2)...?
  382. Can table ownership be changed?
  383. Help - how to concatinate strings from multiple rows?
  384. Translate Function?
  385. data dictionary
  386. SQL Server Performance varies by NT account
  387. Sorry: Trying to understand this piece of code
  388. help with sql script
  389. eseguire un dts
  390. update data in a field
  391. Which Raid?
  392. pick list values into a table
  393. multiple values into a table
  394. Recovering from transaction log deletion in 6.5
  395. MSDE & Web Pages
  396. A question of SP technique...
  397. SQL Mail and SQL Agent Mail @!~$%!%#^$%&^#&#%
  398. memory utilization
  399. export view table into excel
  400. Sintaxis mysql
  401. Is it possible to re-reference a column alias from a select clause in another column of the same select clause?
  402. CPU 100%
  403. "dbuse" fails when database name is larger than 28 characters
  404. xcopy command failed in sql server 2000 as scheduled task
  405. Entry point not found with MS SQL Server
  406. "GO" used in a stored procedure
  407. Exporting to Excel
  408. How do I copy a database
  409. View & SP's for just a few users
  410. row number.
  411. Can not create views, tables etc * URGENT*
  412. Caching UDF
  413. decreasing number of records.. is it important?
  414. MS-SQL Server equivalent to Oracle 9i?
  415. Anything wrong with this query?
  416. Help with TEXTCOPY
  417. Difficult query help
  418. help with nested Query
  419. Difficult query: return recordset from concatenated strings?
  420. Creating New Views on SQL 2000
  421. tempdb log full
  422. Link Pervasive SQL Server - how ?
  423. sql server sizing planning - architecture help
  424. DTS vs Excel numeric conversion
  425. Oracle9i: SQL Exam# 1Z0-007 wanted
  426. SELECT DISTINCT with JOIN
  427. how to break out of a cursor and out of a SP all together
  428. Representation for Deleted Entities: difficult question
  429. Looking for a db schema read/write/synch tool
  430. TSQL to run DBCC rebuild_repair on an MSDE 2000-hosted DB
  431. ms access query problem
  432. PK
  433. SQL Server Job Wanted - Philly Metro Area
  434. More on dependecies
  435. DTS Package is dropping trailing spaces
  436. Logging Sql queries
  437. Data Access Laws In the UK
  438. How to Modify a views' SQL source from a program
  439. Scribe Report Generator - beta testers needed
  440. DTS package and Firewall
  441. Locks and "forever runnable" processes
  442. Calculating Hours with Overlapping Times
  443. can't connect to Oracle
  444. uso del top en el mysql
  445. one frontend different type of backends
  446. SELECT DISTINCT
  447. SQL use statistics
  448. Total SQL users?
  449. Alias name for addressing SQL databases
  450. How do I avoid this corelated subquery?
  451. How do i grab a simple list of SQL Server views, tables or sprocs?
  452. SQL and ASP
  453. SQL server and ASP
  454. Index Tuning Wizard - headache
  455. SQL SERVER DBA
  456. convert Access DB to MS SQL with dtswiz(command line)
  457. SQL Server 7 switches to Windows Only Auth on Reboot
  458. How to redirect a DTS package and connections
  459. Stored Proc Recompiling over and over
  460. Get message : The query cannot be excuted because some files are missing...
  461. Remote hosted database - SQLServer 2000
  462. DB increased the size
  463. FTP from within T-SQL
  464. Database Wars: Oracle vs SQL Server Lock Escalation
  465. sqlserver access datatype differences
  466. SQL funnies :o)
  467. REQ:how does one run SQL 2000
  468. Q: Analysis Services Cube Design
  469. Schedule Local Package to perform FTP and DB restore
  470. Check null value of long data type
  471. Query help: need at least one row for each value in each of two columns
  472. Get Current Identity(Procedure)
  473. Generate XML file from stored procedure
  474. Cannot make server as Target server or link from Master Server
  475. SQL server installation reboots my machine
  476. Query length
  477. referencing to a function..
  478. Passing error message to ASP.NET
  479. tuning the sort step of execution plan
  480. How to setup default value using GETDATE?
  481. New version of AbaPerls available!
  482. Help loading data from Excel to Analysis Services
  483. using conditional statement in stored prcodure to build select statement
  484. Help with query
  485. Send formated query result by mail
  486. sql server certifcation website wanted
  487. floating point calculation
  488. System catalog tables?
  489. converting datetime int
  490. Disabilitazione trigger [DISABLE TRIGGER]
  491. Update in SQL Server 2000 slow?
  492. Thoughts about the smart way to a task
  493. Coding in standard SQL ?
  494. 1-multiple to string
  495. displaying related data from a table
  496. PRIMARY file group is full
  497. Recursive Query
  498. Update query
  499. UPDATE query problem
  500. Returning database schemas
  501. Can There be a single Index
  502. I inteded to ask a different question
  503. Maximum Date in a group of records
  504. RDBMS Report Generator - beta testers needed
  505. How to ensure data is no longer on disk
  506. Hiding a SP in Access under Query, but retain Execute on SP
  507. Adding comments to TEXT field...
  508. Inserts failed sometimes ...
  509. INSERT ... SELECT PROBLEM
  510. DTS w/dynamic source & query
  511. problem analyzing logs with lumigent's log explorer
  512. test post - ignore
  513. re-indexing job takes more time
  514. Column Count from Stored Procedure
  515. Comparing and Synchronizing Databases, Tables, Stored Procedures accross servers
  516. Data/Transaction log files for two databases have same file name
  517. SS 2000 Backup programatically
  518. Cannot set job alerts on Notifications tab if a non-sysadmin user
  519. Restore puts copy of user tables in master
  520. sister caught with the kid next store 4033
  521. Quale tipo di indice sulla tabella? Wich kind of index on table..??
  522. problema con la funzione except
  523. Extended SP Questions
  524. What so special about PostgreSQL and other RDBMS?
  525. problem analyzing logs with lumigent's log explorer
  526. test post - ignore
  527. Export & import DTS Packages
  528. Non trovo il link
  529. third party sql tool
  530. Comparing and Synchronizing Databases, Tables, Stored Procedures accross servers
  531. Data/Transaction log files for two databases have same file name
  532. Cannot set job alerts on Notifications tab if a non-sysadmin user
  533. Dirty Read ?
  534. About MDF file
  535. Can not install Reporting Services, Help!
  536. Merge Replication + Structure Changes
  537. Compressed Drive Support in Yukon (SQL2005)?
  538. sister caught with the kid next store 4033
  539. Retrieve a list of db roles from within T-SQL????
  540. Quale tipo di indice sulla tabella? Wich kind of index on table..??
  541. Compare 2 DateValues -> maxvalue in transact sql
  542. problema con la funzione except
  543. Data Structure -- It's been a while
  544. Round funtion on entire columns in MSSQL?
  545. Using results of query in a query
  546. Cant create database with > 4 GB log
  547. storage snapshot
  548. FlexGrid in VB
  549. problem passing UDF scalar result to UDF table function
  550. SQL Server Report Generator - beta testers needed