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. How to solve "Tables or functions 'inserted' and 'inserted' have the same exposed names. "
  2. Openings in an online game company for sql coders
  3. Return results of mulitple select statements in another Stored Procedure
  4. Query runs slower when converted to a view
  5. Poor performance for business day calculation from aspfaq sample
  6. Limiting active processes?
  7. Database design
  8. Delete with 2 keys
  9. Example of Internal SQL Server Error
  10. SQL Server Best Practice Analyzer and T-SQL coding standards
  11. Merge results from two fields
  12. Big table
  13. Problems with joins
  14. How to assign string value to TEXT output parameter of a stored procedure?
  15. Using an if statement
  16. parameterized pass-through queries from Access front-end?
  17. Optimization of a select query
  18. Maintenance Microsoft
  19. A little script help
  20. SQL Server Backup Applications
  21. HELP PLEASE. Query Question.
  22. Help with a Join and Duplicates?
  23. How to extract part of a string
  24. How to upgrade a stored procedure this way?
  25. SubQuery or Temp Table?
  26. Help with dynamic SQL Stored Procedure
  27. Inserting data to tables belonging to different databases
  28. howto check the sql server edition from code
  29. Paper about SQL Server 2005
  30. New to MS Sql
  31. Data transfer
  32. Convert a existing SQL Server 2000 database to 2005
  33. System DSN / Registry
  34. SQL SERVER DBA/ ATLANTA
  35. relation & query
  36. remote stored procedure on MSDE
  37. Fastest way to handle the search
  38. naming column names
  39. help on query
  40. MSDE installation fails due to detection of previous installation
  41. Table size and Computed Columns
  42. trying to avoid using cursors!
  43. How to Go From a Database to A Calendar Format?
  44. Help with 1205 Not raised
  45. cursor vs. select
  46. ASP + SQL loads really slow over intranet
  47. Insert produces error
  48. HELP - SQL Server 2000 Install Files needed urgently
  49. User input in SQL2000
  50. Can stored procs run after handle is closed?
  51. Restore Log Fails Msg:3433
  52. Date Display
  53. Error on link Servere
  54. How to add 2 columns together
  55. Dev. Team - Keeping Three Tiers in Sync
  56. SQL 6.5 migrating to SQL 2000
  57. Import XMS into SQL Server 2000
  58. NTEXT vs NVARCHAR for large number of columns
  59. Crear una BBDD desde VB.NET
  60. Memory Mgt in SQL SERVER
  61. Enterprise Manager Date format has changed
  62. Copy a database
  63. loop through a datagrid
  64. How to backup a database into a number of smaller files ?
  65. SQL Like.
  66. MS ACCESS - ON DELETE CASCADE Problem
  67. Query Optimization
  68. sp_send_cdosysmail - Parameter Inside Body of Email
  69. can't do that request
  70. owner of a temp table
  71. Accomodating 'Dummy' Data?
  72. Problem with query and date ranges
  73. Error processing cube with disabled lowest level of shared dimension
  74. Locking Problem: SQL Server
  75. isql error message
  76. How to copy tables from local machine to remote SQL server
  77. Dynamic Build SQL in store procedure based on select
  78. Is it ok to use 100% of SQL Server CPU?
  79. bcp is inserting blank space for empty string
  80. SQL 6.5 - to - SQL 2000 replication
  81. parse XML strings in SQL text field
  82. 3 quick queries
  83. Insert value in an auto-identity column
  84. My db grew 8.2GB in two weeks BUT only 4MB of data added
  85. INSERT violates primary key. Which way out?
  86. Cannot Generate SSPI Context
  87. Distributed transactions with multiple instances of Microsoft SQL Server
  88. email on insert
  89. Enter Default Values for all columns in all tables except Primary Keys
  90. update fields with searched first date record fields
  91. Re-using a calculated sub-select field in a view?
  92. What is wrong with this procedure?
  93. help with santax
  94. How can i copy data
  95. Copy field data from table to another
  96. ((((((((( Can someone post SQL 03 program ))))))))))))))))))
  97. (((((((((( Anyone know where I can pickup MS SQL 02? ))))))))))))))))))
  98. NULL values and Indexes
  99. Installing Without CD - Help
  100. Obtaining business hours based on start and end date
  101. Domino VBA
  102. Is Physical server name stored in the Master database
  103. Renaming logical file names
  104. Utilizing compound indexes
  105. Selecting single sorted row from many column
  106. Converting tables to Upper case
  107. Profiler Trace file format
  108. Join using max value
  109. ZZZZ New text 1/1 New Text Document.txt (1/1) 18
  110. ZZZZ New text 1/1 New Text Document.txt (0/1) 18
  111. filelistonly vs verifyonly
  112. How to connect using C#
  113. audit trail triggers
  114. Checksum not working
  115. Exam 70-229
  116. exec sp_executesql vs. sp_executesql and performance
  117. Need help in Updating multiple rows
  118. CHECK Constraint to prevent a conditional duplicate
  119. Transaction MS SQL
  120. SQL Enterprise Manager and Query Analyzer displaying different Row Counts
  121. Database definitions
  122. urgent
  123. Oledb stored procedure rowset binding
  124. GROUP By clause or DISTINCT clause
  125. Specific Book Recommendation
  126. Question on using patindex
  127. Server not using all available memory.
  128. Grouping columns
  129. Importing Access databases into SQL Server
  130. What is Cardinality
  131. 'Suspect' DB won't open - OS error 32- Help!
  132. Inserts gradually slow down
  133. SQL Union with ORDER BY
  134. Need help with complex(?) querie
  135. isqlw.exe
  136. Restore Production database to Development
  137. Duplicate Reference Numbers using MAX()+1
  138. sql charindex split string
  139. Determine Quarter End and Beginning Dates
  140. owner data objects
  141. Transaction log shrinking... weird behavior?!?!?!?
  142. SQL Server: command line support
  143. Connecting to SQL Server 2000 on another subnet
  144. Front-end website search using Full-Text
  145. Count consecutive numbers
  146. local data
  147. .RMD or RMX. to sql server
  148. Which is better? Int or smalldatetime(MSSQL)
  149. SQL Server 2000 and Windows Server 2003
  150. a new SQL tool to help maintain SQL code is now out
  151. Many databases vs. 1 database
  152. a new SQL tool to help maintain SQL code is now out
  153. Restore database fails because database is in use.
  154. More on mysterious data loss in mssql2k - a possible solution?
  155. read only database performance question
  156. Dynamic Column amount query
  157. Can someone explain this behaviour?
  158. top keyword and sorting
  159. Count the number of cubes
  160. Column Names with a cursor
  161. Sample ASP Script??
  162. Database backups growing exponentially
  163. sql service run as question
  164. How To PROTECT SQL Server Database Files ?
  165. Database Move
  166. Mysterious loss of data from mssql2k
  167. Great News Blog!
  168. Having Trouble Installing Reporting Services
  169. Query problem
  170. Help with query
  171. Interesting issue with Full Text Search
  172. Tough little trigger
  173. SQL Server Performance
  174. Need help with SQL query
  175. Virtual Server 2003 Issue! Access Denied- Admin web screen !!
  176. Process not getting any memory
  177. Dropping FK Constraints in a Stored Procedure
  178. C#, SQL-DMO, Add FileGroup Issue.
  179. Insert SP results into variable?
  180. No longer need default instance of SQL Server
  181. basic sql question
  182. SQL Server 2000 Table Auditing for HIPAA
  183. Log Shipping Problem
  184. sql server replication performance
  185. Recursive Query ??
  186. Getting SUM Function Result
  187. Executing sql statements
  188. Syntax for updating table variables
  189. Handle SQL errors with severity 10
  190. Timestamp problem!
  191. Error 15401 adding login to SQL Server
  192. SQL database structure question
  193. How display number records in query designer VisualStudio.NET
  194. help on a sql request
  195. Views / Stored Procedures / Updating Records
  196. Compairing updated data base.
  197. Calling Encrypt2 function from Sqlserver select query
  198. manage transaction to avoid locks
  199. Virtual Primary Key = Slow
  200. SQL Server Scalability
  201. SQL Mail
  202. Help! SQL Server error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name ...
  203. access 03 query datashet view problem help
  204. Combine two queries - help please
  205. Import Password Protected File Via DTS
  206. using count somehow
  207. Is it possible to write a format file that skips a few bytes of header in data file?
  208. How do you export?
  209. Dataset Code Debugging
  210. Altering functions and CHECK constraints
  211. Results of SQL SELECT statement into Stored Procedure
  212. Server Reboot
  213. Replication Problem
  214. View Optimization?
  215. SQL Connections using NAT
  216. C#: Running DDL to Create Functions.
  217. Updating a field for multiple records
  218. search engine in SQL server ?
  219. slecting a table using a local variable name
  220. Need help with query that does both timediff & sum
  221. copying data and structure from one database to another
  222. Please help: Create View
  223. Inserting multiple rows with a single INSERT INTO
  224. Cacluated Field
  225. smalldatetime and sorting
  226. Derived Fields
  227. To compare fields between two table
  228. union with sub query
  229. Data import - foreign key question
  230. urgent DB export issue
  231. Vote on a new newsgroup proposal
  232. Windows 2003 - SQL server does not exist or access denied
  233. T-SQL Help
  234. Unable to create a step in a SQLServer Job
  235. Can't connect to SQL Server (developer edition) from another PC?
  236. Help with java connection to MS SQL 2000 with windows integrated security
  237. automatic rename in FROM clause of dependant objects ?
  238. typical audit trail ?
  239. difference between SYSTEM_USER and USER
  240. How to find max from a table by row
  241. HELP: REGEXP accurences count
  242. Inserting to table with dashes in fieldnames
  243. Calculate/create Row Number without identity
  244. sp_attachdb time varies
  245. Exists query with priorities
  246. Date range problem
  247. BCP and Bulk Insert to Linked Servers
  248. How to simplify my endless query. Thanks.
  249. question on trigger/procedure plz reply?
  250. Question on FOR XML issue
  251. sql query help
  252. Help with SQL if statement and adding fields together
  253. treat contiguous records as 1
  254. quick question on SQL server and object support
  255. Null How to handle
  256. Stored proc location
  257. Table Design Question
  258. Change data type during INSERT INTO ?
  259. Urgent
  260. Finding last "whitespace" character in a string?
  261. Question on Idenity Columns
  262. How to handle this Linked Server error trap in SQL2K?
  263. Parse a numeric string from a field
  264. Setting up backups
  265. updateblob
  266. Switched to simple recovery model when will the transaction log shrink?
  267. limiting result set from MS SQL Server Query
  268. How to get info in SELECT directly instead of UPDATE? Thanks.
  269. Can you qry sys tbls to find Triggers, Constrants etc?
  270. How to build database to support user-specified entities and attributes?
  271. Poor performance
  272. working with xp_sendmail
  273. AND query in single column
  274. Stopping a script
  275. How to get a batchjob to run on more than 1 processor ?
  276. SQL Query to return rows only when a max limit on SUM has been reached.
  277. dynamicall execute SP without dynamic sql
  278. Get next unique ID from a table before insert @@identity / Sequence
  279. Sum fields
  280. Exatract Data, thanks.
  281. change license mode on SQL 2k cluster
  282. How do you execute an Oracle Stored Procedure from a SQL Server DTS package?
  283. Query help -- extract data, thanks!
  284. Other than UNION
  285. isnull and ntext variables (short question)
  286. Easiest way to copy a MS-SQL Database from one machine to another
  287. "IN" clause limitation
  288. change to not allow nulls
  289. Converting DateTime
  290. EXEC stored procedure for every line of SELECT result table - how?
  291. Help with WHERE Clause in Stored Procedure
  292. sp_executesql & Output Variables. One Ball#$#%% of a problem.
  293. rollback via query analyser
  294. Handling Schema Changes
  295. BULK INSERT - does it lock the file while reading?
  296. How to convert from ntext to float?
  297. REPLACE ISSUE..
  298. SQL Server 2k - Timezone question.
  299. Updating the same column multiple times in one update statement
  300. Repeating Records!
  301. SQL Server DBA needed for Florida-US
  302. How to apply complex constraints
  303. SQL Reporting Services PDF Chinese Characters Problem
  304. Simple SQL help needed
  305. How to compare Binary and Int colns
  306. Performance -- count(*)
  307. How to build database to support user-specified attributes?
  308. Moving a database from one machine to another and the lack of speed
  309. query to fetch data
  310. Replication Question about job names and categories
  311. External Access
  312. Very unhappy front end developer looking for advices
  313. Record count in all tables
  314. Can SQL Server 7.0 handle a SQL Server 2000 mdf?
  315. low cost method to check database before inserting data
  316. Import data from Adaptive Server Anywhere 7 DB
  317. MULTI-Table Update Queries
  318. stored procedure varaiables
  319. Code page translations are not supported for the text data type. From: 1252 To: 950.
  320. Active directory query 1000 page size limitaion
  321. Java against SQL Server
  322. SQL Server 2000 vs. MSDE
  323. problem making Oracle linked server work
  324. Need Trigger Help
  325. Using Access with SQL Server
  326. trigger event after time period
  327. IF..ELSE in function - unknown error
  328. CHARINDEX and STUFF/REPLACE
  329. Db installation
  330. long time to establish a connection
  331. Connection string for the Ms-SQl Server using ASP.net
  332. Question: changing case on existing records
  333. SQL Server 2000 Book Recommendations? Including Good Coverage of Reporting Services
  334. Pivot Chart Value Axis Scaling Question
  335. Sql query timeout, expensive cast operation?
  336. Single complex INSERT or INSERT plus UPDATE
  337. Outer Join - shifting result set.
  338. How does SQL 2000 Server back up user database?
  339. creating a new numbered column as primary key in a table
  340. best way to compile thousands of TSQL stored procedures?
  341. Where do views and SP's execute?
  342. Default base
  343. sp_spaceused
  344. getting english column names into a german database
  345. Usability Evaluation Study n570
  346. Need help with creating view
  347. SQL Server concatenation error
  348. UPDATE ORDER BY error
  349. DTS Restore from a file
  350. DTS package with unexpected issues
  351. SQL Report/View
  352. Can't register local instance of SQL Server on local server PLUS
  353. Alert on data deletion
  354. data types
  355. Importing .txt to SQL
  356. problem : random error with with IIS6 and MSSQL
  357. SqlServer2000: autonumbering records - how to ?
  358. Asignar a una variable el valor de un campo
  359. How to enable TCP/IP connectons to SqlServer
  360. Ordering, Grouping - HELP!
  361. auto numbering
  362. SQL 2K Backup Log Monitoring
  363. SQL 2005 Integration Services Help
  364. Performance mystery -- SP vs script
  365. Database Restore Woes
  366. SQL Server 2K problem with fractional real values
  367. Query Help, thanks!
  368. Transforming rows into columns
  369. Script to restart replication
  370. How can I find what tables are loaded in memory ?
  371. Windows 2000 Server / IIS / SQL Server 2000
  372. why does a user function require dbo.* and a stored proc does not?
  373. DTS import does not import all rows / records
  374. Table lock
  375. Query not using index
  376. Senior Infrastructure Database Administrator - Calgary, Canada
  377. "Storing an image into Sql Server Database "
  378. Convert Seconds to hours:minutes:seconds
  379. SQL 7 SP 4 Installation Hangs
  380. Connecting to SQL Server from ASP
  381. SQL Statement Tuning
  382. Cloning a table
  383. debugging stored procedures
  384. Enabling Microsoft EFS in a SQLServer 2000 Cluster
  385. character sets in SQL server
  386. collate SQL_Latin1_General_CP850_BIN to SQL_Latin1_General_CP1_CI_AS
  387. syntax question whole word finding
  388. SQL Connection Log
  389. Stored procedure deadlock on self with subquery
  390. Insert Into Column problem ...
  391. T-SQL too big for Task Scedule - HELP!
  392. Using LIKE with underscore and forward slash..
  393. Identity In SQL VS Autonumber In Access
  394. Client connection to SQL Server on shared hosting
  395. SQL Statement Help
  396. Speed cost for using "or" clause and functions on join statement
  397. Design question: Nested views and functions?
  398. various working with dates issues
  399. Another DTS question
  400. Lock:Timeout events
  401. slow performance on specific query
  402. curious result
  403. Anyone interested in getting Microsoftt, CISCO or any other IT CertificationzzzZ
  404. Help, im new to MSSQL
  405. Asking Email Address Up David Portas and Erland Sommarskog
  406. SQL Server/PeopleSoft DBA Needed!
  407. Is there a way to autoincrement a field with mixture of alpahbetic characters and numbers?
  408. Stored Procedure Not Returning Recordset in ASP
  409. SQL Server on chared hosting with client connections
  410. Column calculations
  411. Database performance degrading (again)
  412. Permutate rows based on table
  413. BCP Issue w/Right Truncation
  414. SQL 2000, AS400 and Client Access
  415. Get the field value after INSERT
  416. Question on aggregate statement
  417. Query/Report Help needed
  418. Stand alone client tools installation
  419. Mystery Database IDs in Profiler
  420. Query - check for a string in stored procedure
  421. Report Containing Sequential Dates (removing date gaps)
  422. Update Time Out?
  423. Null & String Ops Again
  424. MS SQL Server - User Rights
  425. Login Confusion
  426. SQL Query - Aggregate data
  427. Script to lock down a regular user?
  428. Concurrency issues with "Tree" structures.
  429. get the description of a column
  430. Problem backing up Database and Transaction Log due to disk space limitations
  431. TSQL: I want to use a SELECT statement with COUNT(*) AS 'name' and ORDER BY 'name'
  432. Complex query help needed....
  433. DTS Package and ASP.NET
  434. Urgent deliverable
  435. Update Query
  436. How to remember last record read
  437. multiple foreign keys on same field, based on other field
  438. ASP to SQL Connection Prob, Same Server, IIS
  439. Using select results in a stored procedure
  440. DB2 User Group Italy - next meetings March 2005
  441. simple division problem
  442. How to Backup Read-
  443. How to Backup Read-Only databases
  444. Dr. Michael Rys on Microsoft SQL Server 2005 and XQuery
  445. Cannot Drop Database
  446. Select first type problem...
  447. 'NETWORKDAYS(start_date,end_date,holidays)' in SQL ?
  448. Database design question
  449. A Query-Transpose of Data
  450. Some Queries
  451. Delete data, but file size increase
  452. Log all commands executed in QA
  453. Profiler not reporting reads accurately
  454. SQLServer Redirector Port 1434
  455. Get list of files in directory using a SP
  456. Format result of sp_helpdb
  457. SQL Monitoring
  458. backing up read-only database
  459. Conversion between Date Formats
  460. Conditional JOIN
  461. execution plans
  462. list of databases in Analysis Services
  463. Full Text Indexes do not fully populate
  464. About SQL field Type
  465. New Question Regarding LOG SHIPPING & MASTERDB
  466. using DTS question
  467. Looking for MCDBA certified individual with a TS/SCI Clearance
  468. Slow SQL Query - Case in Where Stmnt
  469. Help needed to improve the performance of the query
  470. SQL Server reports
  471. Can I EXPORT tables to a backup DB and delete them from my production server?
  472. How to remove WITH FILLFACTOR = 100 when Generate Sql Script ?
  473. How do I get uppercase values returned only.
  474. BCP Beginner - Please Help
  475. Failing replication requiring restart of SQL Agent
  476. aggregate sql question
  477. DataSet Update Problem
  478. Pivot table not showing blank value column ...
  479. Problem with Excel Pivot Table
  480. Security and access rights using local and global groups
  481. Best practices for field sizes
  482. sp_executesql vs. stored proc.
  483. Tricky group by order by query
  484. Tempdb gets out of control when inserting records
  485. How to create a new serverinstance but with old datafiles?
  486. [DBNETLIB]ConnectionCheckForData (CheckforData())
  487. forcing dbsqlexec to exit cleanly
  488. Stored Procedure and multiple keys which could be NULL
  489. Efficiently joining same table twice
  490. Problem Installing SQL 7 or SQL SERVER 2000 on Laptop
  491. Converting Decimal to String W/O Decimal Point
  492. Help with update query please!
  493. BCP Utility - Skip rows..
  494. Importing CSV files
  495. MS SQL 6.5 Unable to connect.
  496. How to check when a stored procedure was last called/executed
  497. error 7965 not a valid recordset property
  498. Date query question!
  499. Simple select question!
  500. SQL-problem
  501. data transform and compare with in a query
  502. Parameterized order by clause: doesn't work
  503. 2 Questions: license Installation and Speed
  504. Spinning Image
  505. Need help / suggestion
  506. 2005 Express - Concurrent Connections
  507. passing a field name into a parameter
  508. Machine Name In Trigger
  509. Assigning column types in select into
  510. Delete rows in Excel From DTS package
  511. Key Lock Hashed Resource Text Value not unique?
  512. Importing Access DB
  513. [mssql][ant] Failed to execute: GO
  514. Syntax problem
  515. Syntax error in update?
  516. Update using an Inner Join
  517. Error with the trigger
  518. Sql Server Developers Licence
  519. Query to tranform rows to column
  520. Need help in log shipping
  521. Using SELECT LIKE with ADO Parameter in ASP Page
  522. access data in remote SQL server with trusted authority
  523. open query help
  524. orphan recods
  525. user defined functions & default parameters
  526. SQL DATEADD function
  527. What's a significant LockTimeout measurment in PERFMON?
  528. Cannot DTS connect to SQL Server 2005
  529. Datatype
  530. Seek method, table-direct, and sql server2005
  531. pass hash (#) table with different structure to stored procedure
  532. Date Compare in SQL Server Stored Procedure
  533. Group by Problems
  534. list schema's of a sql server
  535. Question about SUM and Nulls
  536. SQL Query Help
  537. Auto-increment PK - Use MS or Grow your own ?
  538. Query Analyzer does not see Enterprise manager database and vise versa
  539. Find Missing data from table
  540. SP To create table
  541. T-SQL Cursor Variable..
  542. IF (SQL server)
  543. checking the existance of fields and types
  544. I need help with SELECT statement
  545. tab character
  546. Books on Data Warehouse Performance Tuning for MS-SQL 2000
  547. Backup - Solution Needed
  548. Email on insert in a table
  549. Question: Upper row limit of 6080 characters
  550. Bizarre case behavior.